Excel to Word Merge - zipcodes

[MikeMc]

When I merge data from Excel into either Word or
Publisher labels, it drops the leading zero from the zip
code field. I've tried several data formats to no
avail. Any help?

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

See the following page on fellow MVP Graham Mayor's website

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

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[David22]

Try formating the merge field like this: MERGEFIELD "Zip" \# 00000