View Single Post
 
Old 01-07-2022, 06:29 PM
Kapluke Kapluke is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2022
Posts: 5
Kapluke is on a distinguished road
Angry Populate Word content control fields with data from Excel

Hello, I have about 50 fields set as Rich text content controls, some fields are repetitive, in a word document. As some these field values involve calculation, it will be tremendously helpful to map the data for these content controls from an excel file. This will need VBA, I am guessing.

I am a total newbie at this. I have searched some the previous postings but have not made any headway. This one by "gmayor" was helpful but I am not sure how this code gets executed from excel and populates a particular word document. There is no submit or run button from what i can tell.

https://www.msofficeforums.com/word-...ord-excel.html

I am hoping someone can give me a start with one or two fields to map from excel to word CC and explain how this moves from excel to word, that will be really appreciated. Maybe it is as simple as saving the excel file? Sorry, if I sound stupid but that is where I am. Thanks a bunch.
Reply With Quote