Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 08-14-2022, 04:22 PM
Guessed's Avatar
Guessed Guessed is offline Add content control to all words from an Excel list in a Word document Windows 10 Add content control to all words from an Excel list in a Word document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Import list from Excel into drop-down content control in word shanshan89 Word VBA 10 08-11-2022 11:53 PM
Populate Word content control fields with data from Excel Kapluke Word VBA 8 01-10-2022 05:39 AM
Add content control to all words from an Excel list in a Word document Push Word content control data and excel cells shaztastic Word VBA 13 08-27-2018 06:46 AM
Combo Box Content Control: How to update the list throughout the whole document? deepak_fer Word 9 03-18-2018 04:10 AM
Word 2010 Content Control help - Combo Boxes vs Drop Down List proghy Word 1 09-16-2014 02:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft