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.

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-22
Click the sheet that holds the database or table.

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

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>