Losing ZIP code format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George - 12 Dec 2003 18:45 GMT

I merge from an EXCEL list regularly. After awhile
(believe it or not it works for a few times) Mailmerge
insists on treating the ZIP codes as numbers and supresses
leading 0's.

Selecting a different EXCEL list will not fix. ZIP codes
are appropriately formatted in EXCEL, but WORD ignores the
formatting.

Recreating the original document source will fix.

Does anyone understand what is going on?

Regards,
George

Reply to this Message

Graham Mayor - 13 Dec 2003 09:03 GMT

See the Excel Data section on the following web page:
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
See also
http://www.gmayor.com/formatting_word_fields.htm which has some alternative
suggestions for US zip codes.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I merge from an EXCEL list regularly. After awhile
> (believe it or not it works for a few times) Mailmerge
[quoted text clipped - 11 lines]
> Regards,
> George

Reply to this Message

Don DD - 14 Dec 2003 17:27 GMT

> See the Excel Data section on the following web page:
> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
> See also
> http://www.gmayor.com/formatting_word_fields.htm which has some alternative
> suggestions for US zip codes.

I have found that by formatting the zipcode column as "text", it
doesn't suppress the leading "0", and for me, at least, it carries
over to Word OK when I merge the data. Good luck!
Dondd

> > I merge from an EXCEL list regularly. After awhile
> > (believe it or not it works for a few times) Mailmerge
[quoted text clipped - 11 lines]
> > Regards,
> > George

Reply to this Message