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!