Need to create a VBA code in Excel that reads records from ms spreadsheet and fills out a MS Word template. Need to use MS Mail merge technology, so users can edit the template themselves. Open the file MS Word mail merge template from Excel VBA and push data into mail merge fields.
Number of records: minimum 1 and max is undefined - Table containing the transactions can go to multiple pages. Table header must be on each page, including possible table header formatting.
Look at the attached document this is the simplified format of the word template to be used + sample data in excel.
March 10, 2018
I am looking for a mix of experience and value