dropped lead 0 in zip code Word 2002

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keith - 28 Jan 2004 12:04 GMT

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?

Reply to this Message

Greg Maxey - 28 Jan 2004 12:46 GMT

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 } )

>-----Original Message-----
>I'm attempting a Mail Merge from an Excel 2002 spreadsheet
[quoted text clipped - 5 lines]
>zero to appear on the mailing labels?
>.

Reply to this Message