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.

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.

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

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.

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.

In your Excel data source that you'll use for a mailing list in a Word mail merge, make sure you format columns of numeric data correctly. Format a column with numbers, for example, to match a specific …

For example, you're using mail merge to print your contact list on a single sheet of paper. Use the Next Record rule to tell Word to proceed to the next record without starting a new page.