I am trying to write a macro that merges, then prints and exits without
saving, when the merge is complete.
I have the following, but it gives me a prompt whether or not to save before
it exits. I would like it NOT to prompt, just exit without saving:

Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
wdPrintDocumentContent, Copies:=1, Pages:="",
PageType:=wdPrintAllPages, _
ManualDuplexPrint:=False, Collate:=True, Background:=True,
PrintToFile:= _
False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0,
_
PrintZoomPaperHeight:=0
ActiveDocument.Close

Does anyone know the command to close without prompting to save?
Thanks in advance!

See the article "How to do a mail merge to the printer using VBA, without
displaying the Print dialog" at:

http://word.mvps.org/FAQs/MailMerge/...PrintrWVBA.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Karen Hart" wrote in message
ink.net...
I am trying to write a macro that merges, then prints and exits without
saving, when the merge is complete.
I have the following, but it gives me a prompt whether or not to save
before it exits. I would like it NOT to prompt, just exit without saving:

Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
wdPrintDocumentContent, Copies:=1, Pages:="",
PageType:=wdPrintAllPages, _
ManualDuplexPrint:=False, Collate:=True, Background:=True,
PrintToFile:= _
False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0,
_
PrintZoomPaperHeight:=0
ActiveDocument.Close

Does anyone know the command to close without prompting to save?
Thanks in advance!

Thank you very much, Doug! I really appreciate your time and effort!
Karen Hart

"Doug Robbins" wrote in message
...
See the article "How to do a mail merge to the printer using VBA, without
displaying the Print dialog" at:

http://word.mvps.org/FAQs/MailMerge/...PrintrWVBA.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Karen Hart" wrote in message
ink.net...
I am trying to write a macro that merges, then prints and exits without
saving, when the merge is complete.
I have the following, but it gives me a prompt whether or not to save
before it exits. I would like it NOT to prompt, just exit without saving:

Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
wdPrintDocumentContent, Copies:=1, Pages:="",
PageType:=wdPrintAllPages, _
ManualDuplexPrint:=False, Collate:=True, Background:=True,
PrintToFile:= _
False, PrintZoomColumn:=0, PrintZoomRow:=0,
PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0
ActiveDocument.Close

Does anyone know the command to close without prompting to save?
Thanks in advance!