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.

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.

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.

If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail merge. But if your data source is a tab delimited (.txt) or a comma-separated value (.csv) file, you first need to import the data into Excel, and then prepare it for a 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.

This topic explains how to start the Mail Merge Wizard from Access and create a direct link between a table or query and a Microsoft Word document. This topic covers the process for writing letters.

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.