losing zeros on zip codes when I create mail merge

[MsShagas]

When I merge excel list to Word I lose the first zero of zip code - comes in
as 8401
instead of 08401. How do I correct? Thank you.

 

[Fred from NYC]

Is the ZIP code set up as a string variable in Excel?

 

[Doug Robbins - Word MVP]

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

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


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[MsShagas]

Thank you for your quick reply. Could you please elaborate on set up of "string
variable" - I did format the cells to Special - Zip Code.

 

[MsShagas]

Thank you for your help.

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

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


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP