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

Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if …

You've built a list of contacts and other data that you want to use for a Word mail merge. If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail merge.

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.

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.

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

Use mail merge to print envelopes that are addressed to the people on your mailing list.

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.

Recipients of a mail merge usually come from a list of names and data in an existing list, like an Excel spreadsheet, or your Outlook contacts list. The existing list could also be any database that you can …

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