mail merge

[bb]

Excel 2000 & Word 2000. I'm trying to merge my excel worksheet 3 tab to a
list (catalog) in a Word document with just first and last name listed.
When I get through the clicking, it says there's no data to merge. It's all
there in Excel. How do I get Word to recognize that I want to merge with
the tab 3 worksheet? Should I be choosing the name of the first tab instead
of the third one? I have tried reading the help, but can't find answer to
my particular problem. TIA
bb

 

[Cindy M -WordMVP-]

Hi Bb,

Excel 2000 & Word 2000. I'm trying to merge my excel worksheet 3 tab to a
list (catalog) in a Word document with just first and last name listed.
When I get through the clicking, it says there's no data to merge. It's all
there in Excel. How do I get Word to recognize that I want to merge with
the tab 3 worksheet? Should I be choosing the name of the first tab instead
of the third one?

when using the default connection method (DDE) in Word 2000 yes, you can
select only the first worksheet. So, if you have the choice, just drag the
third tab to the first position, save, and try again.

The alternate way is to use another connection method. Activate the "Select
method" checkbox in the Open Data source dialog box and you'll get a list.
ODBC or the internal spreadsheet converter should both work (although for ODBC
you may need to go through Options and activate all the checkboxes in order to
see the worksheet names in the list).

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

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail