Mail Merge and Zip Codes

S

Susan

I am merging data from Excel into Word for address labels.
For some reason, it's replacing the zip code with
additional 4 digits (eg. 95034-1234) with zeros. It
doesn't seem to recognize them.

Any thoughts on how to troubleshoot? I'm almost to the
point of just getting rid of the extra digits, but then MS
Word will have won. ;)
 
G

Greg Maxey

Susan,

Try Graham Mayor's tips for US Zip Codes contained here:

http://www.gmayor.dsl.pipex.com/formatting_word_fields.htm
--
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
E-mail for additional help, within reason, if you like. I may not
always solve your problem, but no charge if I do. To e-mail, first edit
out the "w...spam" in the displayed address.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leading zero from Zip Code not print on Label Merge 6
Zip codes in mail merge - first digit doesn't display in merge 1
Mail merge prints zip as 0 instead of correct code 3
Zip Codes Dropping Leading Zero 3
Leading 0 in Mail Merge document 5
losing the leading zero when merging zip+4 postal code 1
Zip Code formatting Problem Word 2007 5
Mail Merge and Zip+4 1

Top