Populating a Microsoft Word Document from Microsoft Access VBA

I have an Microsoft Access Application that generates a contract using Microsoft Access reports.  I would like to setup contract templates in Microsoft Word and then use Microsoft Access VBA to export data to the contract and the Word document needs to be locked.  

I know how to code in VBA to export data to Excel, but I have never done it to Microsoft Word.  Also, I have never setup Word Document templates with fields.  

Can someone help point me in the right direction?  

Thanks!
MarilynSenior Business AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
Try to consider other approach - create word merge document with the source - Access table with prepared data. You can open nesessary template from Access
MarilynSenior Business AnalystAuthor Commented:
Ok, thanks.  I'm going to investigate setting up a word merge document.
PatHartmanCommented:
Mail Merge is too limiting.  I've attached a database that shows a basic example of how to do this along with two letters.  On the sample form use the button for the path field to locate the document you want to fill.  For simplicity, all the fields you are filling are hard-coded but this is easy enough to do with tables if you want something more sophisticated.  I have one app used by an insurance company that fills thousands of different documents.  And NO CODING is required to create a new document and link it in to the app.  In fact, the users do it themselves.

Sorry - it's too big to upload.  Please send me a PM with your email and I will send it to you.  Do NOT post your email in this thread.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PatHartmanCommented:
I sent the sample via email since it was too large to post on the EE site.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.