Article ID: 187352 - View products that this article applies to.
This article was previously published under Q187352
This article has been archived. It is offered "as is" and will no longer be updated.
This article describes three methods to attach a Microsoft Excel data source to a Word mail merge main document.
After you perform step 1 of the Mail Merge, use one of the following methods in step 2 of the mail merge to attach a Microsoft Excel worksheet.
Method 1: Accessing Microsoft Excel Worksheet with a ConverterNOTE: To use this method, the Microsoft Excel converter must already be installed.
To access a Microsoft Excel worksheet with a converter, follow these steps:
Method 2: Accessing MS Excel Worksheets with DDEMicrosoft Excel must already be installed.
NOTE: Using DDE allows Word to see only the first worksheet ("Worksheet 1" by default). If you want to use a sheet other than the first worksheet as your data source while using the DDE option, start Microsoft Excel first, then open the workbook and move the desired sheet to the first position. To do this, drag the desired sheet to the first position on the sheet tab bar at the bottom of the current workbook. Save and Minimize the Microsoft Excel workbook.
To access a Microsoft Excel worksheets with DDE, follow these steps:
Method 3: Accessing the Microsoft Excel Files with ODBCThe Microsoft Excel ODBC driver must already be installed.
To access the Microsoft Excel files with ODBC, follow these steps:
(https://support.microsoft.com/kb/116470/EN-US/ )Sheet1 is the Only Microsoft Excel Sheet Available with Word DDE
Article ID: 187352 - Last Review: October 9, 2013 - Revision: 1.1