Change the order in which entries from a data source are merged
- On the Tools menu, point to Mail Merge, and then point to Mail Merge
Wizard.
- In the Select Recipients task pane, click Edit recipients.
- Do one of the following:
Sort by a single
criterion, such as City
- Click the column heading you want to sort by. For example, Last Name
or City.
Sort by multiple criteria, such as City and Postal Code
- Click an arrow next to a column heading, and then click Advanced.
- Click the Sort tab.
- In the Sort by this field box, click the field you want to sort by.
For example, if you want to sort your mailing by company name, click Company Name.
- Click Ascending or Descending to define the order in which the entries print.
For example, click Ascending to have company names printed in this order: A Company, B Company, C Company...
- To further define your sort, go to the next line of the dialog box, and repeat steps 3 and
4. For example, to sort by last name within a postal code, click Last.