Hi,
In my work environment I have to create legal documents where only some specific areas are to be changed, however, the base document remains the same every instance.
I am thinking of automating this documentation by using Excel table to have specific information (which keeps changing with every new client) linking it with Word Doc template.
My Problem: Mail Merge works with individual information (e.g. Name, Surname, Title, Address lines, Phone number, etc. etc.) ... My Excel table does not have any of these, instead have fields like - Client name, Project name, Important dates, number of employees etc. etc.
Any Help on how to use Mail merge in this scenario OR Any macro in Excel which can pick up the template (word doc) and feed in the data from Excel table at the required areas of document.
Bookmarks