Update an existing mail merge address list

You can edit and update your mailing list before you start mail merge, regardless if you set up your mailing list in an Excel spreadsheet or in your Outlook contacts.

Update your mailing list

You can update your mail list before and during a mail merge. The best practice, however, would to make any updates before you begin your mail merge.

  1. Open your Excel spreadsheet or your Outlook Contacts.

  2. Make any additions, deletions, or corrections.

  3. Save and close the file.

Add new entries to your mail merge list in Word

Even if you've started a mail merge, you can still update your mailing list if you typed it in Word.

  1. Open your existing Word mail merge document if it isn’t already open.

  2. On the Mailings tab, in the Start Mail Merge group, choose Edit Recipient List.

    Screenshot of the Mailings tab in Word, showing the Edit Recipient List command as highlighted.

  3. Under Data Source, choose the name of your mailing list file, and then choose Edit.

    Mail merge recipients list options

  4. In the Edit Data Source dialog box, do any of the following:

    • Update the information for a person in your mailing list
      Choose the information, and then change it.

    • Add new people to your mailing list
      Choose New Entry, and then type the information in the shaded row for each column.

      Edit Data Source box

    • In Word 2013 and Word 2016 you have the following option.

      Make more information available for the merge by adding a new column
      Choose Customize Columns > Add. Then in the Add Field dialog box, type the field name, and then choose OK. Then choose OK again, choose Yes to save the changes, and OK to finish.

      Customize Address List dialog box


      • The columns in your mailing list are the merge fields you use in your mail merge document. If you want to include different kinds of information, you can create new columns. For example, in an email merge, you can add a Personal Message column to include a personal note to people you want to thank or to follow-up with.

      • You also can choose a column and use the Move Up or Move Down buttons to change where the column is in the list. After you make the changes you want, choose OK.

  5. Choose OK.

  6. When prompted by Word to update your mailing list, choose Yes.

Now you’re ready to insert mail merge fields in your document. For more information, see Insert mail merge fields.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.