I have a document template made in word that is filled with all the desired information. I would like to create a drop down box to select a contractor and fill in the contractors name, and address in the top left of the documents in a specific place.
How can I accomplish this. The idea is that the seperate excel file can be updated with new contractors and then the form in the word file will update with the new data and the drop down will ONLY be the contractor, after selecting the contractor it would then fill in the address.
Can this be done?
- Test your wits and sharpen your skills. Take the Challenge »
- Outlook Tasks filter tasks by Email accounts
- Why did a bunch of cells randomly turn into time?
- Power BI Server Integration
The help desk software for IT. Free.
Track users' IT needs, easily, and with only the features you need.
2 Replies
I have no clue how to do what you want, but I think that this might help you on your way: //msdn.microsoft.com/en-us/Office2010DeveloperTrainingCourse_VBALab
In fact, I am going to bookmark it for myself.
I would use access and word with vba to do this. The end-result will be the same, I just think it's more easy to make an connection to your database to do that then to excel and you will find more resources to get you going.
For example:
//www.techrepublic.com/blog/howdoi/how-do-i-dynamically-fill-microsoft-word-fields-using-access-data/122
This topic has been locked by an administrator and is no longer open for commenting.
To continue this discussion, please ask a new question.