Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Issues while opening a main document Mail Merge Word

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-03-2010
Member
 
Join Date: May 2009
Posts: 1,945
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.!!

Reply With Quote
  #2  
Old 24-03-2010
Member
 
Join Date: Apr 2008
Posts: 4,642
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.
Reply With Quote
  #3  
Old 24-03-2010
Member
 
Join Date: May 2008
Posts: 4,565
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.
Reply With Quote
  #4  
Old 24-03-2010
Member
 
Join Date: Apr 2008
Posts: 4,098
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.
__________________
Ram requirement for various OS
Reply With Quote
  #5  
Old 24-03-2010
Member
 
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.
Reply With Quote
  #6  
Old 24-03-2010
Member
 
Join Date: Jan 2008
Posts: 3,759
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Issues while opening a main document Mail Merge Word"
Thread Thread Starter Forum Replies Last Post
Blank word document opens while opening original document Loyalpalm Windows Software 6 01-12-2011 11:27 PM
Error Part: /word/document.xml, Line: 2, Column:15212 when Opening Word Document emvicente Windows Software 1 10-06-2011 03:31 AM
How to create a Word for Mac merge document by using Excel data? Dwarner Windows Software 5 12-03-2010 11:24 PM
Merge multiple Word documents into a master document Ocnoob Windows Software 5 28-01-2010 02:15 AM
How to merge excel and word document? Rahman Khan Windows Software 2 07-05-2009 09:39 PM


All times are GMT +5.5. The time now is 07:48 AM.