Results 1 to 6 of 6

Thread: Issues while opening a main document Mail Merge Word

  1. #1
    Join Date
    May 2009
    Posts
    1,954

    Issues while opening a main document Mail Merge Word

    Hi everyone,
    I have linked a main document if the Mail Merge Word to a data source. Now the problem is that when I am trying to open that main document of the Mail Merge, I am getting a message stating that "Opening this document will run the following SQL command".!! I don't know why this message is displaying.?! Thought that someone would be interested in helping me to sort out this problem. Please tell me how to solve this issue while opening a main document Mail Merge Word. Help me as soon as possible.!!

  2. #2
    Join Date
    Apr 2008
    Posts
    4,644

    Re: Issues while opening a main document Mail Merge Word

    When you open a main document Mail Merge in Microsoft Office Word, you encounter the following problem. The following prompt appears :
    • Opening this document will run the following SQL command:
      SELECT * FROM datasource
      Data from your database will be inserted in the document. Are you sure?

    If you click Yes, the main document Mail Merge opens with the data source attached. If you click No, the main document for mail merge without opening the data source attached. This can be the cause for you to using a program such as Microsoft Access or Microsoft Visual FoxPro to open a main document mail merge programmatically when you experience the symptoms.

  3. #3
    Join Date
    May 2008
    Posts
    4,574

    Re: Issues while opening a main document Mail Merge Word

    This prompt exists in all subsequent versions of Microsoft Office and was introduced in Office XP Service Pack 3. This prompt was added in the products listed in the list of products affected by this section to further secure the mail merge. If you click Yes when the prompt appears, you let code run on your computer. An attacker may be able to create a SQL query that is designed to steal or destroy data that you have access. If you click No when the prompt appears, you do not let the code run.

  4. #4
    Join Date
    Apr 2008
    Posts
    4,089

    Re: Issues while opening a main document Mail Merge Word

    Try to change the following registry in Microsoft Word 2007 :
    HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 12.0 \ Word \ Options
    "SQLSecurityCheck" = dword: 00000000

    1. Start Registry Editor.
    2. Locate the following registry key and click:
      HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 12.0 \ Word \ Options
    3. In the Edit menu, point to New and click DWORD Value.
    4. Under Name, type:
      SQLSecurityCheck
    5. Double-click SQLSecurityCheck.
    6. In the Value data box, type:
      00000000
    7. Click OK.

  5. #5
    Join Date
    Apr 2008
    Posts
    2,139

    Re: Issues while opening a main document Mail Merge Word

    If you are working with the Word 2003, then follow the steps :
    1. Start Registry Editor.
    2. Locate the following registry key and click:
      HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 11.0 \ Word \ Options
    3. Click Edit, point to New and click DWORD Value.
    4. Under Name, type:
      SQLSecurityCheck
    5. Double-click SQLSecurityCheck.
    6. In the Value data box, type:
      00000000
    7. Click OK.

  6. #6
    Join Date
    Jan 2008
    Posts
    3,758

    Re: Issues while opening a main document Mail Merge Word

    The workaround mentioned by the 'chroma' and 'ThoMas321' may make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. Also I would like to tell you that serious problems might occur if you modify the registry incorrectly by using Registry Editor or any other method. These problems may require you to reinstall your operating system. To circumvent this problem, disable the security prompt by using the registry key SQLSecurityCheck.

Similar Threads

  1. Blank word document opens while opening original document
    By Loyalpalm in forum Windows Software
    Replies: 6
    Last Post: 01-12-2011, 11:27 PM
  2. Replies: 1
    Last Post: 10-06-2011, 03:31 AM
  3. Replies: 5
    Last Post: 12-03-2010, 11:24 PM
  4. Merge multiple Word documents into a master document
    By Ocnoob in forum Windows Software
    Replies: 5
    Last Post: 28-01-2010, 02:15 AM
  5. How to merge excel and word document?
    By Rahman Khan in forum Windows Software
    Replies: 2
    Last Post: 07-05-2009, 09:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •