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

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 …

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 …

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 want to send a mass mailing to an address list that you maintain in a Microsoft Excel worksheet, you can use a Microsoft Word mail merge. The mail merge process creates a sheet of mailing labels …

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.

If you're using an Excel spreadsheet, format the ZIP Codes or postal codes column as text to preserve any zeros. For more info see Format mail merge numbers, dates, and other values in Excel.

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.

There are two known add-ins for PowerPoint that can help you merge data from an Excel workbook into a presentation file. Read about the add-ins here: Merge for PowerPoint (Answers.Microsoft.com)

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