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


The information in this article applies to:

  • Microsoft Word for the Macintosh 6.0
  • Microsoft Word for the Macintosh 6.0.1
  • Microsoft Word 98 Macintosh Edition
This article was previously published under Q141009

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 sheet that you want from the Microsoft Excel workbook.

    NOTE: You can also specify the entire worksheet or a name or cell range within the worksheet by using the R#C#:R#C# method, where R equals Row and C equals Column.
  9. Click OK.
  10. Click "Edit the Main Document."
IMPORTANT: When you save and close the main document, Word will prompt you to save changes to the data document. Do NOT click Yes. If you do, the Microsoft Excel worksheet will not be recognized by Microsoft Excel. Microsoft Excel will display the following error message when you try to open the worksheet:
File format is not valid.
For information on how to perform this task in Word for Windows, please see the following article in the Microsoft Knowledge Base:

116470 Sheet1 Is the Only Excel Sheet Available with Word DDE

Modification Type:MajorLast Reviewed:10/4/2002
Keywords:kbhowto kbinfo kbmerge KB141009
©2002 Microsoft Corporation. All rights reserved.