Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am using MS Word 2013. I have a document that, when opened, prompts me with:

Opening this document will run the following SQL command: SELECT * FROM C:\somepath\somefile.mrg Data from your database will be placed in the document. Do you want to continue?

I am trying to find where in the Word document this data source is being specified, and hopefully remove it completely.

share|improve this question

3 Answers 3

up vote 2 down vote accepted

In many (if not all) cases, answering "No" to this prompt should be enough to disconnect the data source. But you should then save the document, and try opening it again.

If that doesn't work, try to get to the point where the document is open, then open the Mailings tab, click the Start Mail Merge button in the Start Mail Merge group, then select Normal Word Document from the dropdown. Then save the document.

If you don't save the document after disconnecting the data source, the problem will recur.

share|improve this answer

In my case I wanted to un-merge the data - keep the document as a mailmerge but not show peoples' specific details in the document each time I opened it. I finally was able to do this by going through the mailmerge wizard, and when it came to selecting recipients with the little checkboxes, unchecking all of them. When I closed the wizard it looked like a mailmerge form again without individual data; I saved it as a new document to maintain this.

share|improve this answer

If you are using Word 2010, open the document, click on the Mailings tab, click the down arrow under the Start Mail Merge button, click on Normal Word Document. This will disconnect the Word document from the source document.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.