![]() |
#1
|
|||
|
|||
![]()
This is merge Mail code FROM MS ACCESS IT Works fine, but in the end show dialog box SAVE AS . Is it possible to help FOR not show dialog box , but save AS the file directly IN "C:\Users\LABTOP2\Desktop\end_of_ the_merger.docx"
not use the sendkeys Greetings to all Attachment work files Code:
Private Sub COMM1_Click() Dim objWord As Word.Application Dim Doc As Word.Document Dim sDBPath As String Set objWord = CreateObject("Word.Application") objWord.Visible = False 'True Set Doc = objWord.Documents.Open(Application.CurrentProject. Path & "\WORD" & ".DOCX") With Doc.MailMerge .MainDocumentType = wdFormLetters sDBPath = Application.CurrentProject.Path & "\DATA1" & ".XLS" .OpenDataSource Name:=sDBPath, _ SQLStatement:="SELECT * FROM `wordqur1$`" End With With Doc .MailMerge.Destination = wdSendToNewDocument .MailMerge.Execute Pause:=False End With Doc.Saved = True objWord.Quit Set Doc = Nothing Set objWord = Nothing End Sub Last edited by macropod; 08-23-2014 at 03:00 AM. Reason: Added code tags & formatting |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Application.Dialogs - Show mail merge 'Select Recipients" dialogs | Cosmo | Word VBA | 0 | 10-08-2013 07:58 AM |
![]() |
raiya | Mail Merge | 11 | 10-16-2012 11:04 PM |
![]() |
zoysiaspp | Mail Merge | 1 | 09-28-2012 08:23 PM |
![]() |
rutica | Mail Merge | 1 | 06-02-2009 10:25 AM |
opening mail attachment dialog box | jeffcravener | Outlook | 0 | 06-28-2006 07:19 AM |