cancel print in macro

Curt · Guest

when macro runs all is ok. If you cancel print then it goes back to vba.
Looking for a way to close merge document if user cancels print
Here is what I've got
It hangs on execute pause:
Thanks fo help I'm stumped
Sub maile()
' maile Macro
' Macro recorded 8/14/2007 by Curtiss A. Greer
ChangeFileOpenDirectory "\Parade\"
Documents.Open FileName:="ThankMailE.doc", ConfirmConversions:=False, _
ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _
PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _
WritePasswordTemplate:="", Format:=wdOpenFormatAuto
With ActiveDocument.MailMerge
.Destination = wdSendToPrinter
.MailAsAttachment = False
.MailAddressFieldName = ""
.MailSubject = ""
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False (this is where it hangs up have used true also)
End With
End Sub

Google · Sponsor

Doug Robbins - Word MVP · Guest

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

"Curt" <Curt@discussions.microsoft.com> wrote in message
news:967B0CD5-52F7-49C3-91C8-953EB34696E4@microsoft.com...