Losing ZIP code format

[George]

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

 

[Graham Mayor]

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.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Don DD]

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.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

George,

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