Article ID: 178708 - View products that this article applies to.
This article was previously published under Q178708
This article has been archived. It is offered "as is" and will no longer be updated.
This article provides detailed instruction on creating a simple mail merge using data stored in a Microsoft Excel workbook. By following these instructions, you will create a form letter (main document), select the Excel data document, and merge the information in the two documents into a third document.
The following is general information about the appropriate format for a Microsoft Excel worksheet that will be used as a data document in a simple Microsoft Word mail merge.
The data should be in the first worksheet in the Excel workbook. While the data can be in a named range, for this simple merge, the worksheet should contain only the data for the merge. The data should start in the first row of the first column. The first row of data (header row) should contain the field names that will be used to refer to the various columns of data. The field names should be free of punctuation and should consist of a single word per field. Each column that has data in it must have a field name at the top of that column.
TIP: Combining information in separate fields in a merge document is easy; however, separating information in a field is difficult. So, when you create a data document, create as many fields as is practical. For example, you may want to put the first name in a field separate from the last name to make it easy to sort the records in the data document by last name. Keeping the first and last name separate will also make it easy to use only the first name in a salutation.
A1:FName B1:LName C1:Address1 D1:Address2 A2:Betty B2:Smith C2:1401 A St. D2:Apt. 5
Once you have created and saved your data document in Microsoft Excel, use the following instructions to create a form letter and perform a mail merge using the data stored in the Microsoft Excel worksheet.
CREATING THE MAIN DOCUMENTTo create the main document, follow these steps:
Selecting the Data SourceTo select the data source, follow these steps:
EDITING THE MAIN DOCUMENTThe insertion point should be back in Document1 (that is, Document1 should be the active document) and the Mail Merge toolbar should be visible.
To edit the main document (Document1 in this case), follow these steps:
MERGING THE MAIN DOCUMENT AND THE DATA DOCUMENTTo perform the merge, click the Merge To New Document button on the Mail Merge toolbar. This creates a new document containing the results of the merge. This new document can be printed, saved, or deleted without affecting either the main document or the data document.
TIP: Once you have a simple merge working correctly, details can be changed one at a time to increase the complexity of the merge. Be sure to test the merge after each change that is made.
For information about how to do this in other versions of Word, please see the following articles in the Microsoft Knowledge Base:
141922For more information about mail merge and data document types, click the Office Assistant, type mail merge data in the query area of the Office Assistant and click Search.
(https://support.microsoft.com/kb/141922/EN-US/ )WD: How to Start a Mail Merge
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Word Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/179216/EN-US/ )OFF98: How to Use the Microsoft Office Installer Program