Excel as data source loses zero in front of zip code field

[karen_goldsmith]

I formatted the zip code column to be a zip code format,
but when I use this spreadsheet as a data source in Word
2002 mail merge, it loses the "0" in front of the rest of
the zip code.

I researched switches but that did not work and the only
way I could do it was to format the merge field and tell
it to put a "0" in front of the merged text.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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