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.

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) …

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 …

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.

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.

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 …

To reuse your envelope mail merge document, open the document and choose Yes when Word prompts you to keep the connection. To change addresses in the envelope mail merge …

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 …

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