Find out what data source the document is using?

[jamiechen168]

Hello,

As you know if you open a Word document which has Mail Merge fields,
Word will ask you "...Opening this document will run the following SQL
command: SELECT * FROM ..".

I am writing code which needs to analyze a Word document and to
identify the data source used for this document, but couldn't find a
resolution. Can someone give me a clue how we can fetch the name of
Data Source?

Thanks

Below is my pseudo code (C#) looks like?

// Create a Word App obj
myWordApp = new Word.ApplicationClass();

// Load the word document file
String wordFile = "c:\\temp\\test.doc";
bject missing = System.Reflection.Missing.Value;
Word.Document myWordDoc = myWordApp.Documents.Add(ref wordFile, ref
missing, ref missing, ref missing);

// See if we can find out the data source. However dataSource is empty
String dataSource = myWordDoc.MailMerge.DataSource.ConnectString;

 

[Doug Robbins - Word MVP]

Not sure why you want to identify the source, but the following article
gives a method of preventint the display of the message,


"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

http://support.microsoft.com?kbid=825765

After making that modification, it should result in the document opening
with the data source attached to it and then in then (in vba) you could use:

ActiveDocument.MailMerge.DataSource.Name

Can't help with the C# code

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP