Debra Dalgleish posted this to a similar question:
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx
And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he
http://home.earthlink.net/~wordfaqs/...ngWord2002.htm
about half way down the page.
==========
Another way is to cheat!
Use a helper cell with a formula like:
=text(a1,"00000-0000")
and copy down
This will be treated like text in your mail merge.
golfer wrote:
Durham:
Did you ever figure out how to include the zip+4 into the mail merge
document? I need help now with it..can't seem to get it. Thanks!
"Durham" wrote:
I have a name/address document set up in Excel and when I try to do a mail
merge for address labels into Word, the addresses that have the extended,
9-digit zip code won't print the zip code. All that prints is a "0". Anyone
else have this problem or know a solution?
--
Dave Peterson