Excel Help

[leisa.p]

I am trying to do a mail merge from my Excel database and a Word doc.
Thezip code is giving me problems. Any Zip Codes beginning with 0 do
do not merge correctly. I have tried everything. I have tried as
text as numbers as special with zip and still no luck. PLEASE HELP I
have a mailing that has to get done.

 

[David Biddulph]

You can either use the field formatting options within Word, or in Excel you
can use the TEXT function to format the number appropriately.

 

[Barb Reinhardt]

Don't send anything to the NE United States?

Try the suggestion here

http://blog.ptraining.com/2005/08/displaying-zipcodes-in-a-word-mailmerge/

 

[Dave Peterson]

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/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.