need to print standard letters to query results group

[Graham26]

Hi All, forgive my ignorance/ inexperience. I need to print a set of letters to a group of say 20 people, generated from a query result.
Currently i am using the same access query and then opening Mail merge in Word, which works great, and i can select individuals from the list of recipients.
I would like to keep it all within Access 2010, if possible
I have also worked on an access 2010 database where the generated letters to individuals are all saved and easily referenced- can i create something similar?
i can work through designing the report template but will take any advice/ tips offered on linking fields etc...

Thanks in advance,
Graham26

 

[Trevor G]

If you have this set to mail merge in word then you have the design for your report in Access and all you would need to do is create the report using what ever text you need with the logos, address etc and add the fields in place, check the design out and then if created correctly you should automatically move to another page per record. If connected to a query then all should work ok, failing this copy a sample of the word letter and example of the database with the query and you can upload and get some better advice.