![]() |
|
#2
|
||||
|
||||
|
Other switches don't work with the \b and \f switches (even the \* MERGEFORMAT switch won't work). For what you want, you need an IF test coded along the lines of:
{IF«Cash_Credit»<> 0 "You were selected to receive a cash credit of {MERGEFIELD Cash_Credit \# $,0.00} which will be mailed to the address we have on file."} Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the 'Insert Merge Field' dropdown.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Using multiple IF statements on a mail merge
|
ajh19742000 | Mail Merge | 1 | 11-01-2016 06:11 PM |
Multiple mail merge
|
PKAYHORM | Mail Merge | 1 | 09-29-2013 07:45 PM |
Multiple Mail Merge?
|
imogul | Mail Merge | 1 | 06-24-2011 07:20 PM |
| Mail merge switches | Jan Collier | Mail Merge | 0 | 08-29-2010 06:06 AM |
| Help with switches: Word mail merge with Excel | ks_ | Mail Merge | 0 | 12-09-2009 05:09 PM |