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.

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.

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.

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.

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 mail merge to print envelopes that are addressed to the people on your mailing list.

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 …