Create user specific documents from template using values stored in spreadsheet

[Yonk1]

Good Morning All,

I’ve been attempting to generate user specific documents from a template, but I cant seem to get it working.

I have all the information in an excel spreadsheet and would like to create a personalised copy of the template for each row of the spreadsheet.

Essentially, the code needs to be able to:

• Open a .html/.txt file
• Find 5 separate static value’s within the text file and then replace them with corresponding Values from columns B-F.
• Save a separate copy of the document using the value supplied in column A as the file name.
• Close the file.
• Loop through the previous 4 steps for each row of the spreadsheet.

I've found scripts for performing individual parts of this (E.g find/replace text in a document, "save as" using values from various cells, looping through etc...), however my attempts to combine them have produced some pretty appalling results!

Thanks in advance to anyone who can point me in the right direction.