WD2000: Cannot Select Named Range from Excel During Mail Merge (211283)
The information in this article applies to:
This article was previously published under Q211283 SYMPTOMS
When you perform a mail merge using a Microsoft Excel worksheet as your data source and using the Microsoft Excel Worksheet via Converter (*.xls; *.xlw) option, you can select only the entire worksheet and not a named range from Excel.
WORKAROUND
To use a named range from Excel during a mail merge within Microsoft Word, use one of
the following methods.
Method 1: Connect to Excel with DDE
Microsoft Excel must already be installed.
NOTE: Using DDE allows Word to see only Worksheet 1. If you choose to use
the DDE option, start Microsoft Excel first, and then open the workbook and
move the sheet you want to the first position. To do this, drag the sheet you want to the first position on the sheet tab bar at the bottom of the
current workbook. Save the Microsoft Excel workbook.
To connect to Excel using DDE, follow these steps:
- Start the Mail Merge Helper.
- From the Get Data list, click Open Data Source.
- Locate and select the Microsoft Excel file. (In the Open Data Source
dialog box, make sure that the Select Method check box is selected.)
- Click Open.
- In the Confirm Data Source dialog box, select MS Excel Worksheets via
DDE (*.xls). Click OK.
- In the Microsoft Excel dialog box, select the Entire Spreadsheet or
Named or Cell Range option from the list. Click OK.
- Edit the main document and continue with the merge process.
Method 2: Connect to Excel with ODBC
The Microsoft Excel ODBC driver must already be installed.
NOTE: In the Select Table dialog box, you see all the tables in the
workbook, not just the ones from the first sheet.
To connect to Excel using ODBC, follow these steps:
- On the Get Data list, click Open Data Source.
- Locate and select the Microsoft Excel file. In the Open Data Source
dialog box, make sure that the Select Method check box is selected.
- Click Open.
- In the Confirm Data Source dialog box, select Excel Files via ODBC
(*.xls), and click OK.
- In the Select Table dialog box, specify the table from the list (which only shows the first worksheet in the workbook) or click Options
and select System Tables, and specify the worksheet you want to use.
Click OK.
- Edit the main document and continue with the merge process.
Method 3: Save the Excel Worksheet in Excel 5.0/95 Format
To save an Excel worksheet in Excel 5.0/95 format, follow these steps:
- In Microsoft Excel, with the worksheet open, click Save As on the File
menu.
- In the Save as type box, select Microsoft Excel 5.0/95 Workbook (*.xls).
- Click Save.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 12/6/2000 |
---|
Keywords: | kbbug kbmerge KB211283 |
---|
|