First off hello from DuPont WA. I am an Assistant principal at our middle school. Here is my project (and issues):

I created an excel document for each grade level with the fields being:

Student Name, Teacher Name, #Missing Assingments, Period


I have sorted data and even added another field with numbers assigned to each student but I can not figure out how to move on.

ie


1 john doe mrs smith 3 2 (1 being the assigned #)
1 john doe mrs brown 2 4

2 joe doopie mrs smith 5 2
3 Sue double mrs smith 3 4

I would like to have a letter go to john doe with his missing work on one page then joe doopie get his own letter (same info) with his missing work and so on.



Im really a newbie to mail merge so any help would be HUGE!!!