View Single Post
  #8   Report Post  
Dave Peterson
 
Posts: n/a
Default

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