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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

karen_goldsmith@merck.com - 25 Feb 2004 18:07 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 25 Feb 2004 23:42 GMT

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

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

Signature

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

>I formatted the zip code column to be a zip code format,
> but when I use this spreadsheet as a data source in Word
[quoted text clipped - 4 lines]
> way I could do it was to format the merge field and tell
> it to put a "0" in front of the merged text.

Reply to this Message