Zip codes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathanna - 23 Aug 2004 21:14 GMT

I am trying to do labels using mail merge.
The data is coming from an excel spreadsheet.
My zip codes are mostly in Connecticut and therefore have
a leading zero ex. 06810.
When my labels come out in mail merge it keeps dropping
the leading zero in the zip code.
Any suggestions?
I've already tried setting it up as special - zip in
excel and also tried custom with 5 digits.
Thank you.
Kathanna

Reply to this Message

Doug Robbins - 24 Aug 2004 00:40 GMT

Add a formatting switch as shown to the mergefield that returns the zipcode

{MERGEFIELD "ZIP" \# "00000"}

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am trying to do labels using mail merge.
> The data is coming from an excel spreadsheet.
[quoted text clipped - 7 lines]
> Thank you.
> Kathanna

Reply to this Message