Applies ToWord for Microsoft 365 Word for Microsoft 365 for Mac Word 2024 Word 2024 for Mac Word 2021 Word 2021 for Mac Word 2019 Word 2019 for Mac Word 2016 Word 2013

Recipients of a mail merge usually come from a list of names and data in an existing list, like an Excel spreadsheet, or your Outlook contacts list. The existing list could also be any database that you can connect to. If you don't already have a list, you can type one up in Word as part of the mail merge process.

The list or database is known as the data source for your mail merge.

Choose which type of list you're going to use as your data source:

New list

If you don't have a data source yet, choose Type a New List, and then use the form that opens to create your list. The list is saved as a database (.mdb) file that you can reuse.

For details about creating a new list, see Set up a new mail merge list with Word.

Existing list

An existing list might be an Excel spreadsheet, Access database, or some other type of database. To use it as your data source, choose Use an Existing List.

Important: No matter what type of file you use as a data source, be sure to save it on your local computer or a file share; saving at an HTTP location isn't supported for mail merge.

  • Excel spreadsheet    An Excel spreadsheet works well as a data source for mail merge if all data is well-formatted and on one sheet so that it can be read by Word. For more information, see Prepare your Excel data source for a Word mail merge.

  • Access database    With Access, you can select data from any table or query defined in the database. For more information, see Use mail merge to send Access data to Word.

  • Other database files    To access other kinds of data sources, you'll run the Data Connection Wizard:

  1. Go to Mailings > Select Recipients > Use an Existing List, then choose New Source to open the Data Connection Wizard.

    data source mail merge

  2. Choose the type of data source you want to use for the mail merge, and then select Next.

    Data Connection Wizard

  3. Follow the prompts in the Data Connection Wizard to complete the data connection to the merge document.

Outlook contact list

You can retrieve contact information directly from your Outlook contact list in Word. To use this as your data source, choose Choose from Outlook Contacts. For more information, see Use Outlook contacts as a data source for a mail merge.

Need more help?

Want more options?

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