Code for Automation / Auto populate Excel Data in Word documents at specified locations

[gr8mechguru]

I am very new to VBA Coding field.

I need a VBA code for following problem.

I have an excel database and word templates (5 Nos Word Template files).

I need to Auto populate the data from Single Excel file to Multiple Word templates (5 different templates).

In word template I placed bookmarks which I have named in Word where I would like these values to be returned to.

Few bookmarks are repetitive in all Word templates, means same data is to be populated in multiple word files.


I need help how to automatically fetch word templates from a Single Folder. Then Populate data in word templates. then save word file in a different folder.

 

[jdellasala]

Assuming your using Windows (missing from your Profile), and since you're working with two different Office apps, you might consider looking into Power Automate. It's part of 365 so Free, Web Based, and also has a Desktop app. I haven't used it much, but I think you'll have a MUCH easier time doing what you need to do with it rather than with VBA. (Truth - not a fan!).