Mail Merge - Excel to Word Macro Edit

  • Hello,


    Below is the macro I am using and it is working nicely, but I need help with a tweak and can't get it to work.


    This macro, enabled in Excel, is part of a chain of macros and will open Word, run the mail merge, save and close Excel. However, there is a macro in Word that I need to run but don't know how to activate it. Is there a code that I am missing that can be added to the end of the macro included?


    Thank you,


  • Re: Mail Merge - Excel to Word Macro Edit


    JSpectrum,


    The simplest way of doing this would be to put your macro in the wdoc under the Document_Open() thus allowing the macro to run upon opening of the word document

  • Re: Mail Merge - Excel to Word Macro Edit


    The only issue with that is that the macro needs to run after the mail merge is complete... Would I insert that towards the end?

  • Re: Mail Merge - Excel to Word Macro Edit


    I would run a seperate sub at the end of the mail merge macro allowing the code to flow from one directly into the next

  • Re: Mail Merge - Excel to Word Macro Edit


    Please excuse my ignorance, but I guess I am not fully understanding how to do this... Is there a command I can simply insert into the existing macro? If not, I'm not sure if one code can simply run a word macro in Excel.. But if it can, please elaborate.

  • Re: Mail Merge - Excel to Word Macro Edit



    Code
    1. wdApp.Run "macroname"