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?
 
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.
1
 
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
0
 
MarilynSenior Business AnalystAuthor Commented:
Ok, thanks.  I'm going to investigate setting up a word merge document.
0
 
PatHartmanCommented:
I sent the sample via email since it was too large to post on the EE site.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.