WD: How to Use Excel 5.0 Worksheet as Data Document in Mac Word

• Microsoft Word for the Macintosh, versions 6.0, 6.0.1
• Microsoft Word 98 Macintosh Edition

SUMMARY

This article describes how to use the second or subsequent worksheet in a Microsoft Excel workbook during a mail merge in Word.

MORE INFORMATION

To use the second or subsequent worksheet of a Microsoft Excel workbook in a Word mail merge, follow these steps:

1. Close Microsoft Excel if it is running.

2. Create a new Word document.

3. On the Tools menu, click Mail Merge.

4. In the Mail Merge Helper, click Create and then click one of the merge types (for example, Form Letters).

5. Click Active Window.

6. Click the Get Data button and then click Open Data Source.

7. Locate and select your Microsoft Excel worksheet and then click Open.

8. In the Open Worksheet dialog box, select the desired sheet from the Microsoft Excel workbook.

   NOTE: You can also specify the entire worksheet or a name or cell range within the worksheet.

9. Click OK.

10. Click "Edit the Main Document."

   File format is not valid.

MORE INFORMATION

For information on how to perform this task in Word for Windows, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q116470
   TITLE     : Sheet1 Is the Only Excel Sheet Available with Word DDE