Graham

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Quote from the "CreateADataSource.htm" page.

I can only see the first worksheet of my Excel workbook when I open my Data
Source.

By default Word uses the DDE method to connect to Excel. In the Open Data
Source dialog box, check the “Select Method” option to view other methods.

Select Method Notes:
Excel files via ODBC: Named ranges are displayed by default. To specify a
worksheet, click Options and select System Tables.

Microsoft Excel Worksheet via Converter will convert your worksheet into a
Word document. If the file is saved in Word, it will permanently convert your
Excel workbook into a Word document. You will no longer be able to open this
file in Excel. Be cautious when using this method.


Gord Dibben Excel MVP


On Mon, 31 Jan 2005 01:41:04 -0800, Graham
wrote:

I'm using a workbook of some 50 sheets as data source for mailmerge to word
document. Each worksheet needs to be a source for separate mailmerges. When I
try to alter data source , it ALWAYS goes to the first worksheet. How do I
force it to go to subsequent , or ideally, my preferred worksheet, as the
data source?
Using Word/Excel 2000 in Windows 98!
Many Thanks