Please advice me!

I have an access database that has a query that produces a table like this:

PupilName:Surname:Class:Target1:Target2:Target3
Test :Test :Art : .....

The query has over 10000 records as each of the 1000 pupils at the school
studies at least 10 subjects.

I want to produce a report that parents can have.

My Question: how can I create a mail merge that will collate all the
classes with targets for each pupil.

So each page will be dedicated to an individual pupil and then a page break
would start a report for the next pupil etc.

I hope this is clear.

Thank you very much in advance for your help.

Desi