Below is a example of a Microsoft Word 2010 Mail Merge that has me stumped. I need to format the Cash_Credit field as two decimal field, however since there are already Before and After switches, it gets confusing. I have searched and cannot find any discussions or examples of this particular scenario. I would like to include/combine another switch, such as \# $ ##.00

Alt + F9 View


{MERGEFIELD Cash_Credit \b “You were selected to receive a cash credit of”\f which will be mailed to the address we have on file.” \* MERGEFORMAT}

Normal View
You were selected to receive a cash credit of «Cash_Credit» which will be mailed to the address we have on file.

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]

Great recommendation, Paul! Thanks for the fast reply.

The IF works! it populates the before and after text, including the Cash_Credit value. However, having one small issue now. When the source value contains no data (null; empty cells in Excel) the Comparison Operator <> doesn't identify this, but still populates the before and after text.

i.e. You were selected to receive a cash credit of which will be mailed to the address we have on file.

Also, here are a few things that I've tried, but didnt work:
>= 1
!= 0



Any additional help will be greatly appreciated.

Try replacing the 0 with "".

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Paul, your suggestion worked! but, I had to change the logic slightly so that the before and after text did not populate when there was a null value in the cell.

here's what I ended up using.

{IF { MERGEFIELD Cash_Credit \*MERGEFORMAT} = "" "" "Before test {MERGEFIELD Cash_Credit\# $,0.00;;} after text."}

Much appreciation to you and this great forum!