Mail Merge Calculations

[mashoutposse]

Hi,

I am trying to change th ourpt of a mail merge field with a calculation if it is possible. If a field returns as false I would like the other field to change to "0" if not I would like the field to remain the same.

I have tried the code below but it is not working.


{IF{MERGEFIELD Whiskey_Glasses}=”False” {MERGEFIELD WhiskeyBoxes = “0”}}

Thank You

 

[Larry]

IF{MERGEFIELD Whiskey_Glasses}=”False” {MERGEFIELD WhiskeyBoxes = “0”}}

It looks like you are missing some syntax operators (quote marks, spaces, etc.). I am not a programmer, but I had similar issues. Here is what I suggest:

Under the "Mailings" menu click on "rules" then pick "If...Then...Else". Select the Whiskey_Glasses field under Field Name; "Comparison" should be set to equal to and "compare to" should be set to False. Then populate the "Insert this text" with some text to identify where it is in the statement. Leave the "Otherwise insert this text" box blank. Then click "OK".

Next display the code in the word document using the Alt+F9 keys.

Then using the placeholder text from before, you can insert the WhiskeyBoxes field by selecting it from the Insert Fields command in the ribbon. then add your = “0” statement. Be sure to delete the placeholder text, but leave the code in place.

I hope this solution works for you.

Larry