Letter in forms

[LG]

I currently have a form that processors fill out and the data feeds into a
table. They then have to go to word and pull up the template and go through
all the mail merge steps and pull the query I created that has a parameter
for letters that they need to print. Is it possible to build a form in
access to match the word template and they can just click a button an print
directly from access. It would save many steps for them and eliminate many
different places etc they would need to go? Or if that is not possible, is
it possible to build a macro that automatically will open the word template
right from access they would just need to select the correct query and then
print right from there? Let me know if you need more information or if this
does not make any sense.
Thank you

 

[Allen Browne]

To do this in Access, create a report.

The report will be based on your query. Say you want to send the merge
letter to each client, and list all the products they're interested in. Your
report would have a grouping based on the ClientID. The address panel for
the letter would go into the ClientID Group Header section, the products go
in the Detail section, and then the ClientID Group Footer would contain the
signature.

For the ClientID Group Header section, set its Force New Page property to
Before Section, so each letter starts on a new page.

 

[Daryl S]

How about creating a report in Access that mimics the Word template? Then
you can use the query as the source of data, and print directly from Access.
The form would just have the criteria needed to select the correct records
and a print print / print preview button to press.