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 generate a set of output documents:
The main document contains the basic text that is the same in all of the output documents. It may contain a letterhead, text, and instructions in merge fields for inserting text (such as recipient names and addresses) that vary from one output document to another.
The recipient list is a database that contains the data that is to be merged into the output documents. For example, the recipient list is a Microsoft Access database file or an Excel worksheet.
This database is typically a list of names, addresses, phone numbers, and other categories of personal information.
The output documents are the result of the mail merge. The text in an output document can be the same in all output documents, but you can apply formatting to specific documents.
