WD98: How to Create a Merge Document Using Excel Data

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 mergeusing data stored in a Microsoft Excel workbook. By following theseinstructions, you will create a form letter (main document), select theExcel data document, and merge the information in the two documents into athird document.
More information
The following is general information about the appropriate format for aMicrosoft Excel worksheet that will be used as a data document in a simpleMicrosoft Word mail merge.

The data should be in the first worksheet in the Excel workbook. While thedata can be in a named range, for this simple merge, the worksheet shouldcontain only the data for the merge. The data should start in the first rowof the first column. The first row of data (header row) should contain thefield names that will be used to refer to the various columns of data. Thefield names should be free of punctuation and should consist of a singleword per field. Each column that has data in it must have a field name atthe top of that column.

   A1:FName B1:LName C1:Address1   D1:Address2   A2:Betty B2:Smith C2:1401 A St. D2:Apt. 5				
TIP: Combining information in separate fields in a merge document is easy;however, separating information in a field is difficult. So, when youcreate 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 nameto 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 onlythe first name in a salutation.

Once you have created and saved your data document in Microsoft Excel, usethe following instructions to create a form letter and perform a mail mergeusing the data stored in the Microsoft Excel worksheet.


To create the main document, follow these steps:
  1. Start Microsoft Word 98 Macintosh Edition by double-clicking the Microsoft Word icon in the Microsoft Office 98 folder.

    The insertion point should be blinking in Document1. This indicates that Document1 is the active document.
  2. On the Tools menu, click Mail Merge.
  3. Under Main Document, click Create, and select Form Letters.
  4. Click Active Window.
  5. Under Data source, click Get Data.

Selecting the Data Source

To select the data source, follow these steps:
  1. From the list of commands under Get Data, click Open Data Source.
  2. Navigate to the folder that contains the Excel data document.
  3. Change the List Files Of Type selection if necessary, and then select the data document and click Open.
  4. Click Edit Main Document.


The insertion point should be back in Document1 (that is, Document1 shouldbe the active document) and the Mail Merge toolbar should be visible.

To edit the main document (Document1 in this case), follow these steps:
  1. Type some text in the document.
  2. On the Mail Merge toolbar, click Insert Merge Field, and select a field name from the list.

    Repeat steps 1 and 2 as many times as necessary to create the appropriate text and desired number of merge fields in the main document.

    NOTE: When you merge data, you can use as few or as many of the data fields as you need to and you can use them in any order. Also, each field can be used more than one time.
  3. To save the main document, click Save As on the File menu.

    TIP: The name should indicate that this is a Main document (for example, name the file "My Main Document"). The document should be stored in the same location (folder) as the data document.


To perform the merge, click the Merge To New Document button on the MailMerge toolbar. This creates a new document containing the results of themerge. This new document can be printed, saved, or deleted withoutaffecting either the main document or the data document.

TIP: Once you have a simple merge working correctly, details can be changedone at a time to increase the complexity of the merge. Be sure to test themerge after each change that is made.
For information about how to do this in other versions of Word, please seethe following articles in the Microsoft Knowledge Base:
141922 WD: How to Start a Mail Merge
For more information about mail merge and data document types, click theOffice Assistant, type mail merge data in the query area of the OfficeAssistant and click Search.

NOTE: If the Assistant is hidden, click the Office Assistant button on theStandard toolbar. If Word Help is not installed on your computer,please see the following article in the Microsoft Knowledge Base:
179216 OFF98: How to Use the Microsoft Office Installer Program
form letter mailmerge standard bulk mailing multiple

Article ID: 178708 - Last Review: 10/26/2013 17:27:00 - Revision: 2.0

  • Microsoft Word 98 for Macintosh
  • kbnosurvey kbarchive kbhowto kbmerge KB178708