Microsoft KB Archive/141009

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

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:


 * 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.
 * 1) Click OK.
 * 2) 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

Additional query words: 6.0 Excel Merge

Keywords: kbhowto kbinfo kbmerge KB141009

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.