Debra Dalgleish posted this:

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://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg.)

Gordy99 wrote:

I have the same problem but when I format (right click and choose "format
cells") the Zip Cell in Excel to Zip+4 it works good in excel except in the
formula bar. In Word it shows up as 9 numbers just like the formula bar in
excel.

"Durham" wrote:

Yes, I know it's pulling from the right field because all the names/address
with just the 5-digit zip code come in fine. My worse case scenerio is that
I'll just have to remove the 4-digit extension from those zips that have it;
I was just trying to avoid that - maybe the software is only set up to handle
5 digits in a zip code field. Thanks for the response!

"Lady Layla" wrote:

HAve you made sure the field in Word is correctly pulling the right
information/field from Excel?


"Durham" wrote in message
...
: 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