Hi Phil,
You could suppress that message via Application.DisplayAlerts = False, but that would also cause Word to convert the document from a mailmerge main document to an ordinary document (but with the mergefields in situ).
However, since you're driving this from Access, why are you using a Word mailmerge main document? If you use an ordinary document with the mailmerge fields etc (eg delete your Word mailmerge main document's mailmerge header), then you can programmatically make it a mailmerge main document and add the query when you open it. When you're finished processing, close the original Word document without saving.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|