Deleting zeros when mail merge

[jwatson]

I have a SS that I am attempting to mail merge into Word
to create labels. When I do the beginning zeros on the
zip codes are deleted, no matter what way I format them.
Any help would be greatly appreciated.

 

[Dave Peterson]

I saved this post from Debra Dalgleish (and someday I'm gonna use mailmerge!):

==============

In Word, after you have inserted the Merge fields, press Alt+F9, to view
the field codes.

In the field code for the Zip Code, you can add a switch to format the
number. For example:
{ MERGEFIELD "Zip" \# "00000" }

Press Alt+F9 again to hide the field codes, then view the merged data.

 

[David McRitchie]

or you could just format the column as text before entry.

If the zips are already entered you can fix them up, convert them
to text and then you can also work with Canadian zip codes.
http://www.mvps.org/dmcritchie/excel/join.htm#fixuszip5
--