Zip code formating in mailmerge

[Randy]

When doing a mail merge from Excel into Word (both 2003) the zip code
suppresses the leading zeros in some zip codes and fould up the zip plus 4
codes as well. When you look at the fields format in Excel, it show to be
correct and everything looks fine until it is pulled into Word. Is this some
sort of bug?
I've tried everything from changing the zip field to text, general, number
it doesn''t seem to make any difference
Thanks for any help you can give.
Randy

 

[Doug Robbins]

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

 

[camell]

My zipcode is a little bit different then the examples on this web page. The
zipcodes in my Excel document are like this 02345-9899. I either get
00000-0000 or 0 depending on which format I use. Any other suggestions?

 

[Doug Robbins]

You will need to create a new column in Excel that by using the Left() and
Right() functions combines the first 5 digits with the final 4, and thus
eliminates the -. Then the method on Graham's website will work. It
doesn't work at the moment because

(a) 02345-9899 is not being considered as a number and/or

(b) it is not > 99999

as it would be if the information stored in Excel was 23459899

--
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