Describes how to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet.

How to use mail merge in Word to create custom documents, envelopes, email, and labels.

How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.

Mail merge lets you create a batch of personalized letters where each letter is identical in layout, formatting, text, and graphics, except for personalized parts like the salutation.

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

With your address list set up in an Excel spreadsheet you can use mail merge in Word to create mailing labels. Make sure your data is mistake free and uniformly formatted.

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

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

To reuse your envelope mail merge document, open the document and choose Yes when Word prompts you to keep the connection. To change addresses in the envelope mail merge …

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