I have attached 2 files to give you an idea on what I am trying to achieve: One is an Excel file with small sample data and the other is a Word document that displays the ending results I'm trying to achieve. I don't want to click on a button in the Mailing tab to complete a mail merge (that's manual stuff). I already know how to do that. I want to create a macro in Word to automate everything. What I mean by everything is the moment you click on a macro button it will run a set of code to extract the data from Excel and populated into Word just like the attached Word document. The macro will do the mail merge for me. Many thanks!
|