I've been meaning to search for this problem for ages. Australian post codes
(zip codes) are just four digits long. Whenever I do a Word mail merge to
print labels (and sometimes letters, I think), the post code randomly prints
as a zero (0). It seems to be completely random. It doesn't matter if it's
formatted as text or a number, and the next time round, it'll print OK.

I'll try this DDE and see how it goes!

Phil

--
Sproxton in Sydney


"Durham" wrote:

Thank you so much! I tried all the solutions and found one that worked - the
DDE. It's a pain, but at least it's a solution! Thanks again for taking the
time to point me to that...hopefully I can return the favor some time!

"Debra Dalgleish" wrote:

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


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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html