How do you mail merge with a specific Excel worksheet within a workbook?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 09 Mar 2004 15:01 GMT

I select Tools / Mail Merge / Get Data / Open Data Source. I then select the Excel file

It then asks me if I want to merge with the "Entire Spreadsheet" or just the "Print_ Area"

I can't get it to link to a specific worksheet within the workbook. It only seems to function properly with a spreadsheet that only has one worksheet

Is this a limitation of the program? Or am I missing something?

Reply to this Message

Peter Jamieson - 10 Mar 2004 08:47 GMT

If you are using Word 2000 or earlier, the default connection method (DDE)
only lets you see the first sheet and range names within it. You need to
check "Select method" in the Open Data Source dialog box then select either
ODBC or the Converter option to see anything else (ODBC is probably the
better bet). With ODBC, you will need to check the Options button in the
next dialog box and check all the options (Tables, views, system etc.) to
see all the things you can connect to.

If you are using Word 2002 or later, I believe you should already be seeing
all the possible sources within the data file.

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I select Tools / Mail Merge / Get Data / Open Data Source. I then select the Excel file.
>
> It then asks me if I want to merge with the "Entire Spreadsheet" or just the "Print_ Area".
>
> I can't get it to link to a specific worksheet within the workbook. It only seems to function properly with a spreadsheet that only has one

worksheet.

> Is this a limitation of the program? Or am I missing something?

Reply to this Message