Office 2007 Bible

Using Excel Data in a Mail Merge

To use Excel data in a mail merge in Microsoft Word, you select the Excel file holding the database or table as the recipient list (use the Select Recipients button in the Start Mail Merge group on the Mailings tab in Word) during the merge process. The Select Table dialog box, shown in Figure 19-22, prompts you to specify which worksheet in the file holds the database list or table. Click the sheet, and then click OK.

Figure 19-22. Click the sheet that holds the database or table.

[View full size image]

You can then use the choices in the Write & Insert Fields group (Figure 19-23) on the Mailings tab in Word to insert fields from the database.

Figure 19-23. Inserting fields from the Excel database for a merge.

[View full size image]

Cross-Ref

For more information on mail merge, see Chapter 10.