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

MORE INFORMATION

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."