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 …

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 …

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.

If you don't have a mailing list, you can create one during mail merge. If you're using an Excel spreadsheet, format the ZIP/postal codes column as text to avoid auto deletion of leading zeroes.

In the Mail Merge Recipients dialog box, click the name of the data source and then click Edit. In the Edit Data Source box you can edit or delete existing addresses, or add new entrys.

If you want to send a mass mailing to an address list that you maintain in a Microsoft Excel spreadsheet, you can use a Microsoft Word mail merge. The mail merge process creates a sheet of mailing labels …

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.

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

Use mail merge rules such as fil in, if/then, next, previous, or skip record to customize your mail merge.