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

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.

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

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.

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.

If you don't have a mailing list as a source for names and addresses in a mail merge, you can create one in Word.

Choose the type of data source you want to use for the mail merge, and then select Next. Follow the prompts in the Data Connection Wizard to complete the data connection to the 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 …