I am trying to macro the use of an Excel list and Mail Merge through Word. I am wondering if you can set a macro to the entire Mail Merge process through Excel.
For example, the code below is what I currently have to save and close Excel and open the Word document. I want to take that a step further and point the merge at Sheet2 of the Excel document, start the merge process, then close Word.
Is this possible?
Thank you so much!
Code:Sub Open_Word_Document() 'Opens a Word Document from Excel Dim objWord As Object Set objWord = CreateObject("Word.Application") objWord.Visible = True 'Change the directory path and file name to the location 'of your document objWord.Documents.Open "File path here" ActiveWorkbook.Save Application.Quit End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)