I have created a macro that manipulates some data in excel. Once the data has been manipulated I open up Microsoft Word and run Mail Merge, and point the database to the excel file.
I would like to automate this if possible with one macro. How would I take my existing excel macro one step further to include opening Microsoft Word and running mail merge?