Knowledgebase: Reports and Letters
Opening this will run the following SQL command Word 03 & 07
Posted by Adrian, Last modified by on 21 July 2008 04:30 PM
Using a Collect! report that redirects to a Word 2003 or 2007 template.|
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
When you open a mail merge main document in Microsoft Office Word, you experience one of the following symptoms:
You receive the following prompt:
Opening this document will run the following SQL command:
SELECT * FROM your datasource
Data from your database will be placed in the document. Do you want to continue?
Note If you click Yes, the mail merge main document opens with the data source attached. If you click No, the mail merge main document opens without the data source attached.
In Microsoft Office Word 2007, perform the following action while the prompt is displayed:
â€¢ To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:
A mail merge main document that is opened by using Microsoft Visual Basic for Applications(VBA) does not have the data source attached.
Use this link for a full explanation and fix: