Postal Codes in Word/Excel merge

[joyced]

I have an Excel document that has 5 digit and 9 digit zip codes. How do I
get the 9 digit zip codes to show in the "Postal Code" merge field? The only
thing that shows when I try to merge into Word is a "0." Thank you.

 

[macropod]

Hi Joyce,

In your Word document, you need to add some logic for processing the zip codes. A suitable field coding for this is:
{QUOTE{SET Val {MERGEFIELD ZipCode}}{IF{Val}> 99999 {SET Val {Val \# "00000'-'0000"}}}{=-{=-{Val}-Val}/2 \#
00000;;}{=-({Val}*(-1)-Val)/2 \# ;-0000;}}
where 'ZipCode' is the name of your Zip Code mergefield.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.