Article ID: 816471
Article Last Modified on 1/6/2006
APPLIES TO
- Microsoft Word 2000 Standard Edition
SYMPTOMS
When you click Insert Merge Field in a Microsoft Word 2000 mail merge main document, the merge fields available to you may appear as the following:
AutoMergeField
AutoMergeField1
AutoMergeField2
AutoMergeField3
CAUSE
This problem may occur if the following conditions are true:
- Your mail merge data source is a Microsoft Excel workbook.
-and-
- The data to be used in the mail merge is on a different worksheet other than Sheet1.
-or-
- The data to be used in the mail merge is not located at the top of Sheet1.
RESOLUTION
To resolve this problem, use one of the following methods.
Method 1: Define a Named Range in Excel
If your mail merge data is not located at the top of Sheet1, follow these steps to define the data as a named range:
- Open your data source in Excel.
- Select the range of cells on the worksheet that contains your mail merge data.
- On the Insert menu, point to Name, and then click Define.
- In the Define Name dialog box, type a name in the Names in workbook box, and then click Add.
- Click OK to close the Define Name dialog box.
- On the File menu in Excel, click Save to save the changes you made to the Excel workbook.
- On the File menu, click Close, and then close your Excel mail merge data source.
When you perform a mail merge in Word 2000, the merge fields defined in your Excel data source now appear when you click Insert Merge Field.
Method 2: Move the Mail Merge Data
To move the mail merge data to the top of Sheet1, follow these steps:
- Open you data source in Excel.
- Select the range of cells on the worksheet that contains your mail merge data.
- On the Edit menu, click Cut.
- Open Sheet1, and then click cell A1.
- On the Edit menu, click Paste.
- On the File menu, click Save to save the changes you made to the Excel workbook.
- On the File menu, click Close, and then close your Excel mail merge data source.
When you perform a mail merge in Word 2000, the merge fields defined in your Excel data source now appear when you click Insert Merge Field.
MORE INFORMATION
For additional information about when you cannot select a named range in Excel, click the following article number to view the article in the Microsoft Knowledge Base:
211283 WD2000: Cannot Select Named Range from Excel During Mail Merge
For additional information about incorrect results with Excel data, click the following article number to view the article in the Microsoft Knowledge Base:
204542 WD2000: Incorrect Results When You Perform Mail Merge with Excel Data
Keywords: kbprb KB816471
