WD95: How to Use Microsoft Excel Data Source for Word Mail Merge

This article was previously published under Q187352
This article has been archived. It is offered "as is" and will no longer be updated.
SUMMARY
This article describes three methods to attach a Microsoft Excel datasource to a Word mail merge main document.
MORE INFORMATION
After you perform step 1 of the Mail Merge, use one of the followingmethods in step 2 of the mail merge to attach a Microsoft Excel worksheet.

Method 1: Accessing Microsoft Excel Worksheet with a Converter

NOTE: To use this method, the Microsoft Excel converter must already beinstalled.

To access a Microsoft Excel worksheet with a converter, follow thesesteps:

  1. From the Get Data list, click Open Data Source.
  2. Locate and select the Microsoft Excel file. Make sure that the Select Method box in the Open Data Source dialog box is selected.
  3. Click Open.
  4. In the Confirm Data Source dialog box, Select Microsoft Excel Worksheet via Converter.
  5. Click OK.
  6. In the Open Worksheet dialog box, do the following:
    1. Under Open Document In Workbook, select either the Entire Workbook or a particular Sheet of the Workbook.
    2. Under Name Or Cell Range, select either the Entire Worksheet or Named Or Cell Range.
    3. Click OK.
  7. Click Edit Main Document and continue with the merge process.

Method 2: Accessing MS Excel Worksheets with DDE

Microsoft 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 asyour data source while using the DDE option, start Microsoft Excel first,then open the workbook and move the desired sheet to the first position. Todo this, drag the desired sheet to the first position on the sheet tab barat the bottom of the current workbook. Save and Minimize the MicrosoftExcel workbook.

To access a Microsoft Excel worksheets with DDE, follow these steps:

  1. From the Get Data list, click Open Data Source.
  2. Locate and select the Microsoft Excel file. Make sure that the Select Method box in the Open Data Source dialog box is selected.
  3. Click Open.
  4. In the Confirm Data Source dialog box, select MS Excel Worksheets via DDE. Click OK.
  5. In the Microsoft Excel dialog box, select the Entire Spreadsheet or Named Or Cell Range from the list. Click OK.
  6. Click Edit Main Document and continue with the merge process.

Method 3: Accessing the Microsoft Excel Files with ODBC

The Microsoft Excel ODBC driver must already be installed.

To access the Microsoft Excel files with ODBC, follow these steps:

  1. From the Get Data list, click Open Data Source.
  2. Locate and select the Microsoft Excel file. Make sure that the Select Method box in the Open Data Source dialog box is selected.
  3. Click Open.
  4. Select Microsoft Excel Files via ODBC in the Confirm Data source dialog box. Click OK.
  5. In the Select Table dialog box, specify the table from the list (which will only show the first worksheet in the workbook) or click Options and select System Tables, and specify the Table you want to use. Click OK.
  6. Click Edit Main Document and continue with the merge process.
For additional information, please see the following articles in theMicrosoft Knowledge Base:
116470 Sheet1 is the Only Microsoft Excel Sheet Available with Word DDE
mail merge mm mmh xl5 xl7 xl97 wks xls convert insert datafile data file database base
Properties

Article ID: 187352 - Last Review: 10/09/2013 17:30:27 - Revision: 1.1

Microsoft Word 95 Standard Edition, Microsoft Word 95a

  • kbnosurvey kbarchive kbhowto KB187352
Feedback