Select recipients to include in a mail merge

  1. Make sure that the mail merge main document (main document: In a mail-merge operation in Word, the document that contains the text and graphics that are the same for each version of the merged document, for example, the return address or salutation in a form letter.) is displayed, and that you have selected a data source (data source: A file that contains the information to be merged into a document. For example, the list of names and addresses you want to use in a mail merge. You must connect to the data source before you can use the information in it.) in the Select Data Source dialog box.
  2. In the Mail Merge Recipients dialog box, do any of the following:

ShowUse the check boxes to designate recipients

This method is most useful if your list is short.

  • Select the check boxes next to the recipients you want to include, and clear the ones next to the recipients you want to exclude.

ShowTip

If you know you want to include most of the list in your merge, clicking Select All first makes it easy to clear particular records. Similarly, if you want to include only a few records in the list, click Clear All, and then select the records you want.

ShowSort items in the list

This is useful if you want to see items in alphabetical or numeric order.

  • Click the column heading of the item you want to sort by. For example, if you want to display the list alphabetically by last name, click the Last Name column heading.

ShowFilter items in the list

This is useful if the list contains records that you know you don't want to see or include in the merge. Once you've filtered the list, you can use the check boxes to include and exclude records as described in the previous section.

  1. Click the arrow next to the column heading of the item you want to filter by.
  2. Click any of the following:
    • (Blanks) displays all the records in which the corresponding field is blank.
    • (Nonblanks) displays all the records in which the corresponding field contains information.
    • If your data source contains records that share the same information, and there are ten or fewer unique values in the column, you can filter by specific information. For example, if there are multiple addresses that list Australia as the country/region, you can filter on Australia.

The Mail Merge Recipients dialog box displays only the designated records. To display all the records again, click (All).

  1. Click OK to return to the Mail Merge task pane. Microsoft Word will use the recipients you designated for the merge.

ShowTips

  • For advanced sorting and filtering, click the arrow next to any column name, and then click (Advanced ). Use the Filter Records and Sort Records tabs to set up the sorting or filtering query you want.
  • If you have installed address validation software, you can click Validate in the Mail Merge Recipients dialog box to validate your recipients' addresses.
 
 
Applies to:
Word 2003