dropped lead 0 in zip code Word 2002

K

Keith

I'm attempting a Mail Merge from an Excel 2002 spreadsheet
to Word 2002 mailing labels. Once the Mail Merge wizard
is finished all the information is there except the
leading zero is dropped from the zip code, i.e. 04869
becomes 4869. In the Excel spreadsheet the column "zip
code" is formatted as zip code. How do I get the leading
zero to appear on the mailing labels?
 
G

Greg Maxey

Keith,

I did not get a chance to test with an EXCEL merge, but
try a numberic switch in your mergefield (e.g., {
YourMergeField \# 00000 } )
 

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 Codes 3
My zip code field on the mail merge drops leading zeroes, why? 1
ZIP code problem 2
Initial zeros in zip codes getting dropped in Word mail merges 1
How do I not drop the leading 0 in a zip code mail merge? 2
how do i display leading zeros when mail merge to Word doc 1
Mail merge prints zip as 0 instead of correct code 3
Why do zip codes w/ leading zeros disappear when doing mail merge 1

Top