[Jet]

Word and Excel 2000 - How do I tell Word to use a specific worksheet when
creating a label mailing merge with Word? Whenever I open the datasource a
select the Excel file it automatically merges the data from the 1st
worksheet. I would like to have the 6th worksheet used for my merged data.

[Graham Mayor]

It's been a while since I used Office 2000, but if you set tools options
general confirm conversion at open, you will get the list of appropriate
converters. The old Excel converter should provide the option to select the
sheet, as should the ODBC converter.

--

Graham Mayor - Word MVP

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


Jet wrote:
Word and Excel 2000 - How do I tell Word to use a specific worksheet
when creating a label mailing merge with Word? Whenever I open the
datasource a select the Excel file it automatically merges the data
from the 1st worksheet. I would like to have the 6th worksheet used
for my merged data.