Mail merge using zip code that begins with "0"

[Ann]

How do I print labels using Word mail merge using data
from an excel spread sheet that have a zip code that
begins with "0" (01742). Even though in the Excel document
the column is formatted as "zip code" and appears correct,
when merged into labels using Word mail merge the "0" is
dropped (1742).

 

[Doug Robbins]

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

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


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Ann]

Thanks for responding to this query. The easiest solution
is to put an apostrophe in front of the zero in the excel
spread sheet ('01742). This will cause the merge to
recognize the zero but not reveal the apostrophe.

Thanks for taking the time to reply.

Ann

 

[Graham Mayor]

This is easier than simply adding a mask to the Word field?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>