Select the product you need help with

WD97: ErrMsg in Letter and Envelope Mail Merge w/ Excel DDE Data Source

Article ID: 171596 - View products that this article applies to.

This article was previously published under Q171596

SYMPTOMS

When you perform a mail merge in Microsoft Word 97 using a Microsoft Excel spreadsheet as your data source using a dynamic data exchange (DDE) connection, you may receive the following error message:

This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor.

When you click Details, you receive the following message:

WINWORD caused an invalid page fault in module WINWORD.EXE at <address>

Back to the top | Give Feedback

CAUSE

This problem occurs when all of the following conditions are true:

You are creating a mail merge document that combines both a form letter and an envelope.

-and-
You are using an Excel spreadsheet as your mail merge data source, and select "MS Excel Worksheets via DDE (*.xls)" as the data source.

-and-
You click Cancel on the Envelopes and Labels dialog box, and then click Envelopes and Labels on the Tools menu a second time.

Back to the top | Give Feedback

WORKAROUND

To work around this problem, use any of the following methods.

Method 1: Using the DDE Connection

Before clicking Envelopes and Labels on the Tools menu, select the mail merge fields in the document that you also want to be added to the Envelope.
On the Edit Menu, click Copy.
On the Tools Menu, click Envelopes and Labels.
On the Envelopes tab, press CTRL+V to paste the mail merge fields into the Delivery Address box.
Click Add To Document.
Proceed with the Mail Merge.

Method 2: Use a Connection Method to Excel Other Than DDE

When setting up the mail merge document, select a connection method to Excel other than DDE. To do this, follow these steps:

On the Tools menu, click Mail Merge.
Under Data Source, click Get Data, and then click Open Data Source.
Click to select the Select Method check box.
In the Confirm Data Source dialog box, click to select the Show All check box. In the Open Data Source list, select either "Microsoft Excel Worksheet via Converter (*.xls; *.xlw)" or "Microsoft Excel Files via ODBC (*.xls)."

Method 3: Use Separate Mail Merge Documents

Create the form letter and envelope in two different mail merge main documents. Use the same spreadsheet as the data source for both documents.

Back to the top | Give Feedback

STATUS

Microsoft has confirmed this to be a problem in Microsoft Word 97 for Windows.

Back to the top | Give Feedback

REFERENCES

For additional information about similar problems using Word and Excel, please see the following articles in the Microsoft Knowledge Base:

113705

(http://support.microsoft.com/kb/113705/EN-US/ )

Word Could Not Re-Establish DDE Connection to MS Excel

155179

(http://support.microsoft.com/kb/155179/EN-US/ )

WD: How to Use Microsoft Excel Data Source for Word Mail Merge

Back to the top | Give Feedback

Properties

Article ID: 171596 - Last Review: January 20, 2007 - Revision: 1.1

APPLIES TO

Microsoft Word 97 Standard Edition

kbbug kberrmsg kbinterop kbmerge KB171596

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top | Give Feedback