How do I not drop the leading 0 in a zip code mail merge?

[kevin@pcg]

In New Hampshire we have zip codes that start with '0' and it gets dropped in
my mail merge process. I have the excel field labeled as a zip code field and
it shows up there...
thanks, Kevin

 

[Sam Bullock]

I'm not sure this is the best method but what has worked with me is making
the field in Excel a text not zip code. This will drop your zero in front of
the number at which point I use the CONCATENATE function to combine the zero
and number.

 

[Rich/rerat]

kevin@pcg,

Take a look 3/4 the way down at G. Mayor's website, "Formatting Word fields
with
switches", under the section for US Zip Codes:

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

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


In New Hampshire we have zip codes that start with '0' and it gets dropped
in
my mail merge process. I have the excel field labeled as a zip code field
and
it shows up there...
thanks, Kevin