I currently have an excel spreadsheet which populates some data into a Word Mail Merge Document.
Does anybody know of a macro in which I could
a) Open the specific Word document directly from excel
b) Run the Mail Merge
c) Print the results of the document
I would like this all to happen with the running of the macro. It would save the user from looking for the word doc etc
If anybody could help this would be great