Merge drops lead 0 in zip Codes

T

TBBPMGE

Running into a problem I never experienced previously. When I perform a mail
merge using an Excel address database as a source, Zip Codes that begin with
"0" come through without the lead "0". Example: Excel cell formatted as a
zip code "01234" is merged and displayed on mailing labels in Word as "1234".
 

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

ZIP code problem 2
Zip Codes 3
Mail merge prints zip as 0 instead of correct code 3
Format Zip Codes in Excel for a Mailmerge 2
How do I not drop the leading 0 in a zip code mail merge? 2
Zip Codes 0
Zip Codes 1
My zip code field on the mail merge drops leading zeroes, why? 1

Top