![]() |
|
#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 |
|
|
Similar Threads
|
||||
| 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 |
How to Use Mail Merge with conditions to show some features
|
raiya | Mail Merge | 11 | 10-16-2012 11:04 PM |
Mail Merge Fields Show Up As Track Changes When its Turned Off
|
zoysiaspp | Mail Merge | 1 | 09-28-2012 08:23 PM |
show dialog box
|
rutica | Mail Merge | 1 | 06-02-2009 10:25 AM |
| opening mail attachment dialog box | jeffcravener | Outlook | 0 | 06-28-2006 07:19 AM |