Microsoft Office Tutorials and References
In Depth Information
Topic B: Data sources for the recipient list
Do it!
B-3: Filtering records
Here’s how
Here’s why
1 Click Edit Recipient List
To open the Mail Merge Recipients dialog box.
You’ll create a filter to view only recipients
from Illinois.
2 Under “Refine recipient list,”
click Filter
To open the Filter and Sort dialog box, with the
Filter Records tab active.
3 From the Field list, select State
In the Comparison list, Equal to is selected.
4 In the Compare to box, enter IL
To specify a value for comparison, as shown in
Exhibit 1-11.
Click OK
Only two records are shown in the Mail Merge
Recipients dialog box.
5 Click OK
To close the Mail Merge Recipients dialog box.
6 View the two records
Use the Next Record button.
7 Update and close the document
Search JabSto ::




Custom Search