How can I completely remove a datasource from a document.

I can close a datasource with the code:

ActiveDocument.MailMerge.DataSource.Close

but the next time I open the document I am still prompted that "Opening
the document will run the following sql..."

The only way we have found to remove a datasource is to copy the
contents of the document to a new blank document.

Any suggestions.

-mark gordon

ActiveDocument.MailMerge.MainDocumentType = wdNotAMergeDocument


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"markg" wrote in message
oups.com...
How can I completely remove a datasource from a document.

I can close a datasource with the code:

ActiveDocument.MailMerge.DataSource.Close

but the next time I open the document I am still prompted that "Opening
the document will run the following sql..."

The only way we have found to remove a datasource is to copy the
contents of the document to a new blank document.

Any suggestions.

-mark gordon

That worked perfectly - thank you very much!