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 / March 2005

Tip: Looking for answers? Try searching our database.

Mail merge drops zip codes and replaces with zero

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Shana - 07 Mar 2005 17:17 GMT
Using Mail Merge, I am attempting to make lables in Word with an Excel file
as the data source. I have been using mailmerge for years in other versions
of Office, but have recently acquired Office 2002.

Word appears to be reading the source list incorrectly.  At the point in
mail merge process where I select the recipient list, a dialogue box pops up
with a version of the recipient list.  (At that point I can select or
deselect records, etc.)  In the zip code column, some of the records have
been replaced with a single zero.  In the original excel file, the there are
no blank fields.  

It seems that the records that are affected were added or edited after i
used the excel file for a merge.  I then added some records and created a new
merged document because the first hadn't worked properly.  I noticed that
some zip codes were missing and i thought it was a problem with the source
file so I created a new file using the same data.  it didn't help.

I have read through the postings on the subject and tried the suggestions
but I'm still having the same problem.  

I hope someone can help!
Graham Mayor - 07 Mar 2005 23:21 GMT
See the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Using Mail Merge, I am attempting to make lables in Word with an
> Excel file as the data source. I have been using mailmerge for years
[quoted text clipped - 18 lines]
>
> I hope someone can help!
 
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.