I am preparing an agreement for several different people and I want a Macro/VBA to automate the process.
i have an excel file containing two columns Full Name and Contact Address.
I want the Full Name and Contact Address to be inserted into a Word document file which is an agreement. At the end of the process, if there are 200 names and addresses, i should end up with 200 new files each named according to the full name that is contained in it.
Sample contacts file and the template are …
