[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 147
  • Last Modified:

Printer dialogue in a mail merged document from access

For mail merging I am using following code:

    Set WWapp = CreateObject("Word.Application")
    Set WWdoc = WWapp.Documents.OPEN(dok & ".dotx")
    WWapp.Visible = True
    With WWdoc
        .MailMerge.MainDocumentType = wdFormLetters
        .MailMerge.OpenDataSource name:=dok & ".txt"
        .Application.Dialogs.Item(88).Display
        .MailMerge.Destination = wdSendToPrinter
        .MailMerge.Execute
    End With


The problem is, that in the dispalying printer dialogue I can change the printer only. All other manual settings including the cancel button will be ignored. How can I solve it?

Thank you very much.
0
User2008
Asked:
User2008
1 Solution
 
Rgonzo1971Commented:
Hi,

the cancel problem is resolved by

Res = .Application.Dialogs.Item(88).Display
If Res = 0 Then Exit Sub

Regards
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now