Exporting to MS Word.

[Mshorthouse]

We have a contract and what we would like to do is be able to input our
client info into a database using MS access, and then have it automatically
input that info into our Contracts, and Client Info sheets, that way we can
cut about an hour off the time we spend on each client, and save us
money...I.E.: where it says Client name in the Contract, have it
automatically input the Client name from the Access Database.....is this
possible, and if so....how do I do this?

 

[John Nurick]

It's possible; in fact can be set up either to have Access create a Word
document and insert the data, or to have Word go fetch the data from
Access. The following links will help you get started:


Opening a new Word document based on a template through Automation
http://www.mvps.org/access/modules/mdl0043.htm
ACC: Sending the Current Record to Word with Automation
http://support.microsoft.com/?id=209976

Access a database and insert into a Word document the data that you find
there:
http://www.word.mvps.org/faqs/interdev/GetDataFromDB.htm