Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can use mail merge to create and send bulk mail and to create envelopes and labels. Your mailing list is the data source for mail merge. Word pulls information from your mailing list and inserts it into your mail merge document.

Sort recipient list

There are many ways to sort your recipient list. The steps below provide you with just one example of what can be done to sort records.

  1. Select the Sort Records box down arrow, choose the column name in your Excel mailing list that you want to sort by, and then choose Ascending or Descending as the sort order.

    As part of Word mail merge, choose Edit Recipient List, and under Refine recipient list, choose Sort.

  2. (Optional) Select the Then by box down arrow, choose the name of a second column that you want to sort by, and then choose Ascending or Descending as the sort order.

  3. (Optional) Repeat step 2 if you need to add another column name to sort by.

  4. Choose OK and see sort results.

    Note: The recipient list now is in ascending alphabetical order.

See also

Watch Take mail merge to the next level - A free training video.

In some instances, you may not want to use all the information in your mail merge recipients list. You have the option to select just some of the people in the list, and also sort and filter the data, so you include only what you want in the mail merge.

Sort the list to find groups

You can sort your list of recipients to group your information in certain ways.

  1. Select Mailings >Filter Recipients.

  2. Select Sort Records > Sort By, and choose the field name you want to sort by.

    Click Sort Records to sort items in the mail merge

    To sort by multiple fields, select Then By, and then select the additional fields you want to sort by.

    Click to sort by multiple fields

  3. When all of the fields are sorted how you want, click OK.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!