Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-22-2014, 08:24 AM
tariqaleed2 tariqaleed2 is offline After the Mail Merge not show dialog box Windows 7 32bit After the Mail Merge not show dialog box Office 2010 32bit
Novice
After the Mail Merge not show dialog box
 
Join Date: Jul 2014
Posts: 14
tariqaleed2 is on a distinguished road
Default After the Mail Merge not show dialog box

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
Attached Files
File Type: zip saveas.zip (45.5 KB, 12 views)

Last edited by macropod; 08-23-2014 at 03:00 AM. Reason: Added code tags & formatting
Reply With Quote
 



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
After the Mail Merge not show dialog box How to Use Mail Merge with conditions to show some features raiya Mail Merge 11 10-16-2012 11:04 PM
After the Mail Merge not show dialog box Mail Merge Fields Show Up As Track Changes When its Turned Off zoysiaspp Mail Merge 1 09-28-2012 08:23 PM
After the Mail Merge not show dialog box 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft