How do I merge multiple rows into one letter?

[Guest]

I have a excel file with student names, status, highschool name. I want to
merge it into a word document (memo) that is directed to the highschool.
There are several names and status' to each highschool. For example: there
may be four names and status' with one highschool. How do I get the
highschool name to show up once at the top of the memo and then the list of
multiple names and status' in the body of the memo.

 

[Guest]

I believe you can only do this by having all your names/status in a single
row as MM processes a row (record) per document:

e.g Column headings would be:

School, Name1,Status1,Name2,Status2, etc

HTH