Populate Word template with data from textbox

[Kevo]

Hi All,



I am in the design stages of putting together a database and have a question...

Can I create an inventory item with a field (text) that has a description - when user presses a button, that description (text) populates in a certain area on a Word document. If so, how hard is this to do?

Thanks
Kevin

[June7]

I expect the VBA would have to open the Word document as an object that can be manipulated. Somehow find the location for the input, maybe a bookmark in the Word document, and then insert the text, save with the edit, and close the VBA object. Most threads in forum on Word interaction concern Word merge, although I seem to remember a discussion similar to your requirement. Finding it again would be a challenge.

Maybe this has clue http://stackoverflow.com/questions/8...rom-access-vba

[NTC]

just to add FYI; from Microsoft they provide the core Word Merge feature in Word whereby you link to an Access table/query to provide the data. Think mass mailings - where you have some boilerplate info in your Word doc/template but want to have unique Address, greeting, and maybe other stuff in the mass mailing so it is personalized.

Access provides the record set - let's say 50 records. Word provides the template. Then with Word Merge you press a button and get a 50 page Word doc that you can print.....