 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2006If...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. {IF {MAILMERGE evnttype} = "OTSC" "{MAILMERGE "date"} {MAILMERGE "time"} {MAILMERGE "room"}" "unscheduled" } }  SignatureHope 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 >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 [quoted text clipped - 9 lines] > > st. Works fine. Thanks, Doug. (So simple I'm kicking myself....) st. > {IF {MAILMERGE evnttype} = "OTSC" "{MAILMERGE "date"} {MAILMERGE "time"} > {MAILMERGE "room"}" "unscheduled" } } [quoted text clipped - 12 lines] >> >> st. Did anyone ever respond to this? I have the same issue... >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 [quoted text clipped - 9 lines] > > st. 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 > Did anyone ever respond to this? I have the same issue... > [quoted text clipped - 11 lines] >> >> st.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.