I am encountering a problem for a few hours now and I am stuck. In short, I have a word template with bookmarks named “LetterOfNotice.docx”. The data to fill in these bookmarks is within excel. The first automation is fine (for each row), it picks out the correct word template and fills in the bookmarks. The automation then saves the file (still within the for each row operation) in the “LetterOfNotice_LastName_FirstName.docx” format.
When the second iteration starts, the automation has overwitten the word template file, and thus the original bookmarks are lost, resulting in an obvious error.
Please see attached a screenshot of my automation.
I feel like I am close, but not sure what is going wrong. If you have an answer, please let me know the logic behind it as I am learning still