Exporting Access info into Word doc

[kirnavi]

Hi - I am trying to figure out the best way to launch a Word document from Access and populate the Word fields with info from Access. I need to do this from within Access, as opposed to making a mail merge doc in Word and using Access as the data source. Once the Word document is populated, I need it then sent as an email attachment to our Accounting department.

The postings I have found on this do not seem to fit my situation and I'm having a little trouble seeing the light.

Any ideas?

Thanks.
Susan

 

[Adine]

Hi Susan

Check out this MS article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q131583

I've done it and it works. Basically you create bookmarks in your Word document, then from Access use code to open the document and replace the bookmarks with specified fields from the current record.

Hope it helps
Adine

 

[Zepher2]

This site:

http://www.helenfeddema.com/

Has code samples to accomplish this. Also includes instructions and a sample db. I used the code to open word from a template and populate the fiels from the active form in access.