mail merge missing records

[Hogan]

My problem is similar to marti's. I'm working with Excel 2003 and Word 2003,
merging into labels. Out of 2000 records, only 15 Zip Codes are being merged.
Data appears in Excel spreadsheet but is not appearing in Mail Merge
Receipients window. What should I do?

 

[Graham Mayor]

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, you will be
given the option of using the DDE method of connection which should read the
data as you have it formatted in the table.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Hogan]

Thanks for the response, but unfortunately it didn't work. I wasn't given
the option of using DDE. Other suggestions?

 

[Graham Mayor]

See the Excel Data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm Do you get the
dialogs shown there?

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Hogan]

Wow, this is going to take time to review. Thanks, I'll get back to you.

 

[Hogan]

The issue is resolved. Thanks for your assistance.

 

[Graham Mayor]

You are welcome

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>