Announcement

Collapse
No announcement yet.

Excel to Word, Mail Merge Macro to Automate

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel to Word, Mail Merge Macro to Automate

    Hello all,

    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

  • #2
    Re: Excel to Word, Mail Merge Macro to Automate

    Bump.

    Comment

    Working...
    X