When I open a Word document with links (for instance a mailmerge) I get a dialog "Yes" or "No" to allow SQL access. I select "Yes" and away I go.



When I open the same document from VBA it opens without showing the dialog, having assumed that the answer is "No". Then I can't do anything with the document.

Is there a way from VBA to open the document to the dialog so that I can answer the question as "Yes" ?

Or is there another workaround to open the document with SQL access ?

Many thanks

I turn the document into a non-mailmerge document before saving and closing it. Then, the vba to open changes it back to a letter mailmerge prlimary and attaches the data source.

Thanks Charles - I'll try that workaround

Hi,
I've looked, but cannot find how to . .
"Then, the vba to open changes it back to a letter mailmerge prlimary and attaches the data source."
Could you point me at appropriate instructions please ?
Thank you,