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!

See the Excel data section of
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

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




Shana wrote:
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!