Article ID: 141009
Article Last Modified on 11/21/2006
APPLIES TO
- Microsoft Word 6.0 for Macintosh
- Microsoft Word 6.01 for Macintosh
- Microsoft Word 98 for Macintosh
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:
- Close Microsoft Excel if it is running.
- Create a new Word document.
- On the Tools menu, click Mail Merge.
- In the Mail Merge Helper, click Create and then click one of the merge types (for example, Form Letters).
- Click Active Window.
- Click the Get Data button and then click Open Data Source.
- Locate and select your Microsoft Excel worksheet and then click Open.
- 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.
- Click OK.
- 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:
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
Additional query words: 6.0 Excel Merge
Keywords: kbhowto kbinfo kbmerge KB141009