Friday, March 18, 2016

SQL Warning in Word

Merge Ahead!

When you open a Word  mail merge main document that is linked to a data source, you may receive the following message:

Opening this will run the following SQL command:

SELECT * FROM C:\file_name.log

Data from your database will be placed in the document. Do you want to continue?

SQL Warning

This message helps protect you from unintentionally sending data to a malicious user.
To suppress this message, you must first create the following registry key:

  1. Open Registry Editor.
  2. Locate, and then click the following registry key:


    (Use 12.0 for Word 2007)

  3. Click Edit, point to New, and then click DWORD Value.

  4. Under Name, type:


  5. Double-click SQLSecurityCheck.

  6. In the Value data box, type:

Microsoft KB 825765

Installing Office XP SP3 appears to cause the same problem. For Word 2002 (XP also known as 10.0) you need to place the registry key in: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Word\Options

(Thanks to Brian Livingston at for pointing the way to a solution)

See all Topics

No comments: