Automating search for Word mail merge data sources (1 Viewer)

[georgedwilkinson]

We are updating our SQL Server this Wednesday night and a last minute issue has cropped up to threaten our implementation.

We are changing all of our Access front ends to use DSN-less connections and won't be updating the DSNs on the client machines. We did a pretty thorough check of all the Access MDB front-ends that connect to the server so we could update them to use the DSN-less connection. The assumption up until this afternoon was that all of the mail merge Word documents connected to one of the MDB files to get their data. However that assumption has been called into question today and I know little about mail merge documents.

What I'd like to know is if there is a Word object that I can use in VBA to find the data source for the current mail merge on a Word document. My intent is to iterate through all the mail merge docs (they're thankfully all in the same directory on the network) and then check to see if any of the data sources point at the SQL Server (which is undesirable).

Does anybody know of a way to use Word automation to find out the mail merge data source?

 

[vbaInet]

Not really done Merge to word but from the links below what you're looking to do should be fairly straightforward.

http://www.tek-tips.com/faqs.cfm?fid=3237
http://msdn.microsoft.com/en-us/library/aa140183%28office.10%29.aspx

1. For each word document in the folder
2. In the MailMerge collection of the current document, check the OpenDataSource method to get it's Name property.

BTW the reference is MS Word 12.0 Object Library

Hope it helps!