Suppress Print-Options-Dialog within MailMerge.Execute

[Günter Haas]

I've subdivided one MailMerge in multiple Print Jobs (for Porto
optimization). The complete MailMerge is processed in a Loop with
corresponding SQL-Selects. With starting every ("Batch"-)Job with
MailMerge.Execute a implizite Print Options Dialog appears.

Question:

How can I suppress this Print-Options Dialog?

Code:

...
ActiveDocument.MailMerge.DataSource.QueryString = sSQLString
Set sd = ActiveDocument.MailMerge
With sd
.Destination = wdSendToPrinter
.MailAsAttachment = False
.MailAddressFieldName = ""
.MailSubject = ""
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
If (.ActiveRecord = wdNoActiveRecord) Then
Exit Sub
End If
End With
If .State = wdMainAndDataSource Then
.Execute Pause:=True
End If
End With
...

[Doug Robbins]

Hi Günter,

Have your macro execute the merge to a document, print the document and then
delete it.

Hope this helps
Regards,
Doug Robbins - Word MVP

Please post any response to the Newsgroups so that other may benefit
therefrom or contribute thereto.
Günter Haas <ha...@proconnection.de> wrote in message
news:#9zCzS0q#GA.247@cppssbbsa03...