Article ID: 170410
Article Last Modified on 1/20/2007
APPLIES TO
- Microsoft Word 97 Standard Edition
This article was previously published under Q170410
SYMPTOMS
When you insert an If Then Else field into a Microsoft Word 97 envelope mail merge, and you use a Microsoft Excel worksheet as a data source with the default dynamic data exchange (DDE) method, you may receive the following error message:
When you click Details, you receive the following message:
WORKAROUND
To work around this problem, follow these steps:
- On the Tools menu, click Mail Merge.
- Under Main Document, click Create, and then click Envelopes.
- Click New Main Document.
- Under Data Source, click Get Data, and then click Open Data Source.
- In the Open Data Source dialog box, click to select the Select Method check box.
- In the Files Of Type list, click to select MS Excel Worksheets.
- Select the Microsoft Excel worksheet that you want to open, and then click Open.
- In the Confirm Data Source dialog box, select either "Microsoft Excel Worksheet via Converter" or "Excel Files via ODBC" and then click OK.
NOTE: Do not select "MS Excel Worksheets via DDE," as this causes the error message described in the "Symptoms" section of this article.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Word 97 for Windows.
MORE INFORMATION
For more information on how to use Microsoft Excel as a data source in a mail merge, please see the following article in the Microsoft Knowledge Base:
155179 How to Use Microsoft Excel Data Source for Word Mail Merge
Additional query words: 8.0
Keywords: kberrmsg kbfield kbinterop kbmerge kbprb KB170410