Microsoft Office Forums - View Single Post - [Solved] Add content control to all words from an Excel list in a Word document

Guessed · 08-14-2022, 04:22 PM

I would be using Mapped Plain Text Content Controls to do this and the user could import that data from Excel as an XML file. This can be automated with a macro to replace the xml file (or set its values) and avoid working with the text via find and replace.

Your Excel data needs to be in fieldname/value pairs. In Excel this could be a second column eg.
object1...Joe
object2...Smith
object3...123 Main St
object4...Springfield

Your original question would enable you to insert all the necessary Content Controls but would need to include either setting the Title/Tag properties to the fieldname or setting the mapping.

Alternatively, if you are using a find/replace method recommended by Paul, then you would need to make sure you search all stories to get entries in the headers/footers etc.