How would one go about writing a macro that prepares Word documents like letters or reports.
I am using a Userform to enter the information and would like to add a button on the user form that brings up the word document. Ready to print, but does not print it.
I am currently opening the document in Word and using the Mail Merge Wizard, but this takes too much time.
I am using Excel 2010.
Thank you.
I am using a Userform to enter the information and would like to add a button on the user form that brings up the word document. Ready to print, but does not print it.
I am currently opening the document in Word and using the Mail Merge Wizard, but this takes too much time.
I am using Excel 2010.
Thank you.
