?
Solved

Cannot remove Data Source in Word2003 document

Posted on 2007-10-18
3
Medium Priority
?
646 Views
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?
Thanks,
Jack

 

0
Comment
Question by:jgbader
3 Comments
 
LVL 14

Accepted Solution

by:
Glenn_Moore earned 1500 total points
ID: 20108918
can you cut and paste the part of the document that you want into another document?  Then save it under the original name.
0
 

Author Comment

by:jgbader
ID: 20110289
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.
Jack
0
 

Expert Comment

by:AlexionSoftware
ID: 23570940
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?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
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 video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Suggested Courses
Course of the Month13 days, 12 hours left to enroll

755 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