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;