We need copy the same content in word document into different pages with different data in bookmark fields which will be imported from excel .Here I’m attaching the word document and excel file for reference and also I’m attaching the automation screenshot which I tried .
Test_Doc.docx (12.1 KB)
Test_Excel.xlsx (8.69 KB)
@Anilkumark3888 Here is what I would suggest;
- Create a template file with your defined bookmarks. You can use this to populate from your Excel file.
- You would read your Excel file using the normal means to extract whatever data you wanted to go into each bookmark.
- To be safe, I might attach this file to the deployment package or place it in a known location and copy it before opening, so I always had a clean copy of the template.
- Save this as a new file so you don’t overwrite your template.
- When you want to add this to a new page in your “output” file, you can use a second Word connector and the technique outlined here to merge your template file into the “output” file.
This would use as much off-the-shelf connector capabilities as possible. The technique in item 4 is well-explained by Jeff in the link provided, but let me know if this makes sense.
