Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
zSplash zSplash is offline
external usenet poster
 
Posts: 9
Default If...Then... - combining fields

I want to do a If-Then-Else statement in mailmerge such that if a condition
is true, 3 mailmerge fields are added to the document; otherwise, a
text-field (or, a single field) is added. I have tried &( )+ between the 3
fields (to "connect" them). Is there anyway to do it? (I keep getting the
second of the 3 I want to combine and add as the "else" part, which makes
sense...).

{IF {MAILMERGE evnttype = "OTSC" {MAILMERGE "date"} {MAILMERGE "time"}
{MAILMERGE "room"} "unscheduled" } }

TIA

st.


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default If...Then... - combining fields

{IF {MAILMERGE evnttype} = "OTSC" "{MAILMERGE "date"} {MAILMERGE "time"}
{MAILMERGE "room"}" "unscheduled" } }


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"zSplash" wrote in message
...
I want to do a If-Then-Else statement in mailmerge such that if a condition
is true, 3 mailmerge fields are added to the document; otherwise, a
text-field (or, a single field) is added. I have tried &( )+ between the 3
fields (to "connect" them). Is there anyway to do it? (I keep getting the
second of the 3 I want to combine and add as the "else" part, which makes
sense...).

{IF {MAILMERGE evnttype = "OTSC" {MAILMERGE "date"} {MAILMERGE "time"}
{MAILMERGE "room"} "unscheduled" } }

TIA

st.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
zSplash zSplash is offline
external usenet poster
 
Posts: 9
Default If...Then... - combining fields

Works fine. Thanks, Doug. (So simple I'm kicking myself....)

st.

"Doug Robbins - Word MVP" wrote in message
...
{IF {MAILMERGE evnttype} = "OTSC" "{MAILMERGE "date"} {MAILMERGE "time"}
{MAILMERGE "room"}" "unscheduled" } }


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"zSplash" wrote in message
...
I want to do a If-Then-Else statement in mailmerge such that if a
condition is true, 3 mailmerge fields are added to the document;
otherwise, a text-field (or, a single field) is added. I have tried &( )+
between the 3 fields (to "connect" them). Is there anyway to do it? (I
keep getting the second of the 3 I want to combine and add as the "else"
part, which makes sense...).

{IF {MAILMERGE evnttype = "OTSC" {MAILMERGE "date"} {MAILMERGE "time"}
{MAILMERGE "room"} "unscheduled" } }

TIA

st.





  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
David Evans David Evans is offline
external usenet poster
 
Posts: 2
Default If...Then... - combining fields

Did anyone ever respond to this? I have the same issue...

"zSplash" wrote in message
...
I want to do a If-Then-Else statement in mailmerge such that if a condition
is true, 3 mailmerge fields are added to the document; otherwise, a
text-field (or, a single field) is added. I have tried &( )+ between the 3
fields (to "connect" them). Is there anyway to do it? (I keep getting the
second of the 3 I want to combine and add as the "else" part, which makes
sense...).

{IF {MAILMERGE evnttype = "OTSC" {MAILMERGE "date"} {MAILMERGE "time"}
{MAILMERGE "room"} "unscheduled" } }

TIA

st.



  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default If...Then... - combining fields

Yes, Doug Robbins replied with

{IF {MAILMERGE evnttype} = "OTSC" "{MAILMERGE "date"} {MAILMERGE "time"}
{MAILMERGE "room"}" "unscheduled" } }

(all the {} need to be the special field braces you can enter using
ctrl-F9).

Peter Jamieson
"David Evans" wrote in message
...
Did anyone ever respond to this? I have the same issue...

"zSplash" wrote in message
...
I want to do a If-Then-Else statement in mailmerge such that if a
condition is true, 3 mailmerge fields are added to the document;
otherwise, a text-field (or, a single field) is added. I have tried &( )+
between the 3 fields (to "connect" them). Is there anyway to do it? (I
keep getting the second of the 3 I want to combine and add as the "else"
part, which makes sense...).

{IF {MAILMERGE evnttype = "OTSC" {MAILMERGE "date"} {MAILMERGE "time"}
{MAILMERGE "room"} "unscheduled" } }

TIA

st.





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Documents - Locking Fields Jezebel Microsoft Word Help 2 July 31st 06 11:07 PM
Use of fields in templates P Wijnhorst Microsoft Word Help 1 April 12th 06 02:53 PM
mail merge and text form fields Miss Su Mailmerge 1 February 4th 06 09:29 PM
Mailmerge vs. form fields Candace Mailmerge 1 September 8th 05 07:14 PM
Word crashing upon re-use of a template jenwren Microsoft Word Help 5 August 24th 05 11:59 PM


All times are GMT +1. The time now is 01:33 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"