Merging into a Word Template From Access

[zrazzaq]

Hi:
I have written code to gather all the information I need from my main system into a table in Access. Now This table has everything I need to fill out everything on this word template. How do I tell it in code to fill out the necessary items on the word document template. I do not know anything about merging. This is the first time I am doing this and I am lost.
Thanks
Zishan

 

[lameid]

I would set up the word document to perform a mail merge and specify the access table as the source for the data.

Tools, Letters and Mailings, and Mail Merge is the menu sequence to get you started. The wizard will guide you through it, I think.

If you still want to code the merge, then record a memo for finishing the merge within Word and post it here... We can then modify it to run from Access.

 

[zrazzaq]

Ok cool...Let say I have a template already and all the fields are being pick up by a text file. The issue is that it is a manual process for the team and I am automating. How do I go into the template and re-direct it to the table in access. Then how do I write the code in access to automatically do the mail merge from the template and print it. Can this be done?
Thanks
Z