Mail Merge and Zip Codes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan - 08 Nov 2003 00:30 GMT

I am merging data from Excel into Word for address labels.
For some reason, it's replacing the zip code with
additional 4 digits (eg. 95034-1234) with zeros. It
doesn't seem to recognize them.

Any thoughts on how to troubleshoot? I'm almost to the
point of just getting rid of the extra digits, but then MS
Word will have won. ;)

Reply to this Message

Greg Maxey - 08 Nov 2003 02:19 GMT

Susan,

Try Graham Mayor's tips for US Zip Codes contained here:

http://www.gmayor.dsl.pipex.com/formatting_word_fields.htm

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
E-mail for additional help, within reason, if you like. I may not
always solve your problem, but no charge if I do. To e-mail, first edit
out the "w...spam" in the displayed address.

> I am merging data from Excel into Word for address labels.
> For some reason, it's replacing the zip code with
[quoted text clipped - 4 lines]
> point of just getting rid of the extra digits, but then MS
> Word will have won. ;)

Reply to this Message