Feeding a Word Document from Excel Source (not a mail merge)

[Jen75]

Hi,



I have a Word Document consisting of over 600 pages. Each page is for a different person. There is one field in the Word Document that I would like to fill in the corresponding field in an Excel spreadsheet. Values are different for each person.

I have a name field in the Word Document, and it matches with the name field in the Excel file. I was hoping I could get Word to autofill the Excel value based on a name match, but I can't seem to figure out if this is possible and how to do it.

I've researched mail merging, but this is different because I'm starting with an existing document and not a blank template. Recreating this as a blank template in order to use a mail merge is not an option.

The only other alternative I see is to copy and paste the field for 600+ records from Excel to Word, and I'd like to avoid that if possible.

I've attached a sample of the Word Document, the Excel file, and the Desired Result of what I'm trying to accomplish. Any advice would be appreciated.

Thank you!