Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document.

Create and send personalized email messages to everyone on your address list with mail merge.

Here are few examples of data sources you can use for mail merge in Word. Excel spreadsheet. An Excel spreadsheet works well as a data source for mail merge. Data should be on one sheet and well formatted so that it can be read well with Word. For more information, see Prepare your Excel data source for mail merge.

Fixes an issue in which mail merge in Microsoft Word does not work for plain text or for attached mails on a computer that is running Windows 7 or Windows Server 2008 R2.

Use mail merge rules such as fil in, if/then, next, previous, or skip record to customize your mail merge.

This article will help you get answers to the most common mail merge issues when using Publisher: Making changes to a data source or address list during the mail merge process, adding spaces to a merge field so that it looks the way you want it to, saving the merged publication, and printing different merged pages on a sheet (for example ...

You can use mail or email merge when you want to create a large number of documents that are mostly identical but include some unique information. For example, you can use mail merge to create individually customized publications with personalized notes or unique addresses and salutations.

So now that you have the basics of mail merge, let’s try some different options, including printing letters. You can find everything you need on the Mailings tab. Want more? Mail merge using an Excel spreadsheet. Insert mail merge fields. Create and print mailing labels for an address list in Excel. Use Word mail merge for email

Use Address Block, Greeting Line, and other merge fields to create a mail merge file from your mailing list.

Training: Go way beyond basic mail merge commands. Unlock mail merge properties you can’t get to with Word commands alone and closely target your message to recipients.