"0" (08742) does not appear in mailmerge envelope zip codes

[Rob Coombs]

We are havig trouble getting the "0" to appear in the mail merge format on the envelopes when merging from Excel. The zip codes are formatted as such in the excel spreadsheet.
Thank you in advance for any time and assistance you can provide.

 

[Doug Robbins - Word MVP]

Hi Rob,

In the mailmerge main document, use Alt+F9 to toggle on the field codes and
put the mergefield inside the following field construction, using Ctrl+F9
for each pair of { }

{ IF { MERGEFIELD Zipcode } > "99999" "{ MERGEFIELD Zipcode \#
"00000'-'0000" }" "{ MERGEFIELD Zipcode \# "00000" }-0000 }

That will handle both 5 and 9 digit zipcodes, appending a -0000 to the 5
digit ones.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

We are havig trouble getting the "0" to appear in the mail merge format on

the envelopes when merging from Excel. The zip codes are formatted as such
in the excel spreadsheet.