Close quit

[Curt]

Trying to have when print finishes have word close completely so it will
return to a user form that called it. Print dialog window comes up. Is it
possible to have print happen completely then close and not save changes.
Here is what I've tried. Novice as I am need help. This is part of the macro
at the end.
Thanks

With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.Destination = wdSendToPrinter
.MailAsAttachment = False
.MailAddressFieldName = ""
.MailSubject = ""
.SuppressBlankLines = False
With .datasource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=True
End With
ActiveWindow.Close
ActiveDocument.printoutbackground = False
ActiveDocument.Close wdDoNotSaveChanges
activedcoument.Close
wd.Application.Quit
setwd = Nothing

 

[Doug Robbins - Word MVP]

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

http://www.word.mvps.org/FAQs/MailMerge/MergeStraightToPrintrWVBA.htm


--
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