Search results
Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document.
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 first need to import the data into Excel, and then prepare it for a mail merge. Step 1: Set up your data source in Excel
When ready, go to Mailings > Finish & Merge > Merge to E-Mail. Merge to E-Mail is unavailable if you have not selected your default email program. Choose the To merge field, the subject, and whether to send as text, HTML, or as an attachment.
294683 How to use mail merge to create form letters in Word 2002 and in later versions of Word. 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.
Here are few examples of data sources you can use for mail merge in Word. Excel spreadsheet. An Excel spreadsheet works well as a data source for mail merge. Data should be on one sheet and well formatted so that it can be read well with Word. For more information, see Prepare your Excel data source for mail merge.
You can use mail or email merge when you want to create a large number of documents that are mostly identical but include some unique information. For example, you can use mail merge to create individually customized publications with personalized notes or unique addresses and salutations.
Applies To. 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.
Use Address Block, Greeting Line, and other merge fields to create a mail merge file from your mailing list.