How can I find out what data source was used in a merge document?

P

Peter Jamieson

If you can't open the document and it's a .doc, I don't know a way. If it's
a .docx, .docm, .htm or .rtf let us know.

If you can open the document, there are a couple of possibilities, e.g. if
you have Word 2003,

Word|Help|About|System Info...|
then wait....
then
Office 2003 Applicaitons|Microsoft Office Word 2003|Mail Merge

or start the Word VBA editor, and type the following three lines in the
Immediate Window (use ctrl-G to display it if necessary):

print activedocument.mailmerge.datasource.name
print activedocument.mailmerge.datasource.connectstring
print activedocument.mailmerge.datasource.querystring

Peter Jamieson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Width of document changes when merging 1
Page numbering with Merged Document and IF statements 1
Mail Merge Directory Conditional Page Break 0
Mail Merge query 1
Start a mail merge upon opening the document 1
Merge Excel file into Word Document 3
Merging from an Excel file with graphics 1

Top