Mailing current record from Access to Word Template Document

[andrejamih]

Hello everyone,



How could I mail merge data from Access from (current record data) from main form and 5 subforms to Word Document Template, with clicking on button on Access Form?
Also. i would like to open that word document on click of that button and to obtain data placed on right places of word document. I have created query which makes the job easier, but I have repetition for few fields because the query is based on one PK field. I took a print-screen of my query in attachment, so if anybody have some suggestion, I really appreciate that.
Regards!

[ranman256]

In word, you would run the Mail merge wizard, then pick the query you made.

[andrejamih]

Thank you for advice, ranman, but I would like to create button on access form which open a word document with exactly record mailing from access database.