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
Doug Robbins - Word MVP - 12 Jan 2006 20:30 GMT
ActiveDocument.MailMerge.MainDocumentType = wdNotAMergeDocument

Signature
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
> How can I completely remove a datasource from a document.
>
[quoted text clipped - 11 lines]
>
> -mark gordon
markg - 16 Jan 2006 23:15 GMT
That worked perfectly - thank you very much!