Hi Phil,

You can't test the mailmerge datasource location until after the document has opened but, in doing so, you need to either locate it for yourself if Word can't, or allow Word to remove that info from the file. Thus, before you can run the macro, you've either solved the problem or destroyed the evidence ...

What you can do when Word doesn't find the datasource is respond 'Yes' to the SQL prompt, then 'OK'. The next dialogue box tells you where the datasource was expected, including the filename. In the case of the document you posted, it's:
C:\Program Files\TakingLife\merge.txt


After noting the datasource details, you can simply cancel out of opening the document.

Although the datasource details are stored in the Word document (in the metadata towards the end of the file), I've not been able to find any code for reading that from an otherwise closed document with vba.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks very much for that - it helps a lot.

Didnt give me that Path - just showed a message with DSNxjhxgh stuff in.

I can now move on though...fancy not putting the merge file where the documents are - previous programmer did this !!

Thanks Again

phil