Bypass prompt to save Mail Merge template...

[Inquisitor99]

I set up a Mail Merge that will use Word 2000 as the front end and an Access 2000 query as the data source. The merge will be run from a command button on an Access form. Everything works fine, except when I use code to close the Mail Merge template without saving it, I'm still prompted to save it.

Here is the line I'm using to save and close, which I picked up from the following post (

http://www.tek-tips.com/faqs.cfm?fid=5088):

objWordDoc.Save
objWordDoc.Close SaveChanges:=-1


If I try to save it before closing it using code, I get the 'Save As...' dialog box.

Here is the line I'm using to close it without saving it:

doc.Close SaveChanges:=wdDoNotSaveChanges

doc= "path\MailMergeFile.dot"


Does anyone know how to close the Mail Merge template without getting the prompt to save it?

Thanks.

 

[PHV]

objWordDoc.Saved = True
objWordDoc.Close

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Inquisitor99]

PHV - It works great! Thanks a million.