Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2004

Tip: Looking for answers? Try searching our database.

mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Big Rob - 22 Jan 2004 02:52 GMT
I am attempting a mail merge with Word and Excel.  I have
two problems.  The first one is that I am unable to pull
up merge recipients that excludes 2 states.  It seems
that I am only able to exclude one state from my list.  
Any suggestions.  The second problem is that the zip
codes are ommiting the first zero.  So for people with a
zip code of 07039, when the merge takes place, the zip
reads 7039.  I went to the excel worksheet and formatted
the cell for zips, and it corrected the problem on the
Excel worksheet but it still will not bring the correct
zip to the letter.

thanks for any help.
Cindy M  -WordMVP- - 22 Jan 2004 14:52 GMT
Hi Big,

I think I can help you with both these problems, but I first
need to know which version of Word you have, so that I can
tell you the correct commands (don't want to mix you up!)

> I am attempting a mail merge with Word and Excel.  I have
> two problems.  The first one is that I am unable to pull
[quoted text clipped - 7 lines]
> Excel worksheet but it still will not bring the correct
> zip to the letter.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.