Excel to Word Automation

Help
1

We have a Form with two columns : Field Name and Values.
Assume, there are 10 rows in the form. Field Name is pre-filled and ‘Values’ are blank.
The values needs to be picked up from an excel.
Please help me understand:

  1. How can I pick up values from excel and insert in the blank fields,
    Ex: For Name , I need to pick up from an excel file, and fill it in the word document.
  2. How will I identify the corresponding blank space for the field name?

Thanks in advance !

2

Are those Blank Names bookmarked with Corresponding Field Names? In such case you can use “Set Bookmark Content”

3

No they are not bookmarked. Can you please explain me how to work on this approach?
Thanks!

4

Bookmarking is pretty simple.

5

For this approach, the bookmarks will be needed to be added to the sheet, which will require extra steps and alter the original file.
Is there any other way to to pick up values from excel and insert in the blank fields in the word document.

6

I can think of replacing First Name : __________ (whatever it is) with First Name : sachdeva using replace text activity.

7

Tried that, but didn’t work :frowning:
Since the ‘Value’ field is empty, there is nothing I can replace it with …

8

Send me the screenshot of how your word looks like.

1 Like
9

image.png769×169 2.03 KB

This is the sample file that I have attached screenshot of.

Thanks!