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.

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. Newer Windows versions Newer Mac versions

This article explains how to use the Mail Merge feature in Microsoft Word to create and to print form letters by using data from a Microsoft Excel worksheet. When you use the Word Mail Merge feature, Word merges a main document with a recipient list to …

Mail merge is all about mass mailings that you individualize for each recipient. You can add individual elements to any part of a label, letter, envelope, or email, from the greeting to the entire document, even images.

Here are some tips to prepare your Excel spreadsheet for a mail merge. Make sure: Column names in your spreadsheet match the field names you want to insert in your mail merge. For example, to address readers by their first name in your document, you'll need separate columns for first and last names.

To be able to send bulk email via mail merge, you must already have installed a MAPI-compatible email program such as Outlook or Gmail. The following process assumes that you already have the message you intend to send already created to open in Microsoft Word.

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

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

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 that you can connect to.

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