Hi,
I have an Excel spreadsheet with different numbers of students in each registration group that I want to mail merge their data to a single letter on Word.

I can see that there are several examples of similarish situations out there but unfortunately it's been a long time since I had my head around any coding like this and I need to get some reports out as soon as possible.



e.g.
NAME REG STANDARD
Fred Smith A1 Green
Joe Bloggs A1 Amber
Ged Roberts A1 Green
Frank Field A1 Green
Vicky Roberts A2 Amber
Caitlin Smith A2 Red
Luke Edwards A3 Green
Holly Williams A3 Green
Ciaran West A3 Amber

So on the Word document page 1 would tell the A1 tutor all the information about Fred, Joe, Ged & Frank; page 2 would tell A2 tutor about Vicky, Caitlin etc.

I would be really grateful if anyone could give me an idea about the best way of achieving this or even better specific code for the three fields.
thanks
Chris