Article ID: 840936 - View products that this article applies to.
Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/256986/ )Description of the Microsoft Windows Registry
When you open a Microsoft Word mail merge main document that is linked to a data source, the links may no longer function. You experience the following symptoms:
This behavior occurs when the main document is in Rich Text Format (RTF). Microsoft Office 2003 Service Pack 1 (SP1) and the 2007 Microsoft Officeprograms include a fix to prevent documents in RTF from having links to data sources.
To resolve this behavior, use one of the following methods.
Method 1: Save the main document in Word 2003 format or in Word 2007 formatTo save the main document in Word 2003 format or in Word 2007 format, follow these steps:
Method 2: Locate the data sourceYou can re-attach the data source every time that you open the main mail merge document. To do so, follow these steps.
Method 3: Disable the fix in Office 2003 SP1 or in Office 2007Note The following method may not work in all situations. For example, if you use a Microsoft Excel worksheet or a Microsoft Access database as your data source, and the mail merge main document is in RTF, adding the CalcDataFieldOnOpen registry setting may not change the behavior that is described in the Symptoms section. In this situation, you must use method 1 or method 2 to resolve the behavior.
Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
To disable the fix that is described in Office 2003 SP1 or in Office 2007, follow these steps:
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/825765/ )You receive the “Opening this will run the following SQL command” message when you open a Word mail merge main document that is linked to a data source
Contact us for more help
Connect with Answer Desk for expert help.