Cannot remove Data Source in Word2003 document

Posted on 2007-10-18
Last Modified: 2009-04-20
I have a Word 2003 document that somehow (don't know how) seems to act like a merge file with a data source.  When I open this file I get the following dialog box:

Opening this document will run the following SQL command.
Select *c:/ez/ezrrltr.doc
Data from your database will be placed in the document.
Do you want to continue YES  NO
I have researched here and gone to the MailMerge Toolbar/Document Setup and selected "Normal Word Document", saved it and then opened it to get the same dialog box!!

Does anyone have a suggestion?


Question by:jgbader
    LVL 14

    Accepted Solution

    can you cut and paste the part of the document that you want into another document?  Then save it under the original name.

    Author Comment

    Well I tried that yesterday and it did not work.

    Today, however, I copied it, EXITED Word, started it up and pasted it into a new doc and it worked.  Don't know why, would like to know why but you get the points for getting me to try it again a new way.

    Expert Comment

    We use Python to merge Word with datasource. A document/sjablone made on my computer will ask for (my) datasource on a new (customer) computer if Word is already opened (with an active document) on the customers pc. The question is like the one above:
    Opening this document will run the following SQL command.
    Select *c:/ez/ezrrltr.doc
    Data from your database will be placed in the document.
    Do you want to continue YES  NO
    We don't want to bother our customers with this question. AND we make Word invisible whilst merging so: this question is NOET visible to anybody but NEEDS to be awnserd...

    If Word is NOT already open there is NO problem.

    Is there an option (with/in COM) to delete/remove all the datasource from a .dot or .doc document? Or maybe an option to continue and scipping the question?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
    This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
    This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now