Mail merge based on access query (1-many problem)

[Agnus]

I have a query made in access which lists students taught by private tutors. Obviously most tutors teach more than one student. I need to merge this with a form that bills each tutor for an admin fee for the setting up of this tuition.Thus, each instance of the form should list one tutor, and all the students they teach etc.. Unfortunately, Word creates a new record for each instance of student, and does not recognise the query's underlying structure, ie. that there are many students to one tutor. Is it possible to merge in this way? I'd prefer to use this than an Access report as they produce crummy-looking documents on the whole (in the time available).
Or is there a REALLY long way round using vba automation in an Access module?
Good old Microsoft think of everything!
Thanks in advance ...

 

[Guest_imported]

why not keep all your info in access specifically under each tutors name listing every student they have and create a template or form letter for each tutor and merge the student fields into each form letter. Thats the best idea I can come up with..Good Luck