Get the bookmarks from the word document, then set the bookmark to the value of the row that you want from excel. You would use the MicrosoftExcel and the MicrosoftWord components in the Toolbox.

How can we pass the index and value to it? could you please explain it to me?

I am sorry but i dint get you. Could you please explain it in detail/in terms of automation?

My requirement is to set the complete row values into word bookmarks once I click on a button. I am getting the values into message dialog box but How can I set each and every cell value to the respective bookmark. Please help me with the logic?

Thanks & Regards

Anu

Anup, forum will give suggestions as per your requirement but not exact working solution. Below details may help you.

First define required bookmarks in the word document (refer https://support.office.com/en-us/article/add-or-delete-bookmarks-in-a-word-document-or-outlook-message-f68d781f-0150-4583-a90e-a4009d99c2a0) and read values from excel and update in bookmarks. PFA screenshots for reference.

Hi Jayachandra,

Yeah ok thank you. But how can we pass the cell values in getcellvalue dynamically?

If you know row value (assuming cells are fixed) then you can use stringutil concact method and pass this to getcellvaue method.