Ok, so I am trying to send out letters to students showing them how many missing assignments they have. I want to transfer this information using a mail merge. Is this possible? Some students have 2 some have 4 or 5. I want to transfer what assignments they are missing. Here is an example.
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>
Student Name | Course | Period | Assignment | Due Date | Score | Teacher |
Smith,John | J6319B - 2 SPAN 1B | 8 | Stem Change Practice Packet | Jan 9, 2018 12:00:00 AM | 0.00 | Montalvo |
Smith, John | J811 - 3 Math 8 | 5b | Volume of Cones | Jan 8, 2018 12:00:00 AM | 0.00 | Dasilva |
White, Nicole | J0211B - 3 ALG 1B | 4b | 4-1 HW Graphing Ineq # 1-10 | Jan 4, 2018 12:00:00 AM | 0.00 | Sloan |
White, Nicole | J804 - 2 English 8 PreAP | 3 | Independent Reading Intro Page #! | Jan 4, 2018 12:00:00 AM | M | Hannam |
Doe, Jane | J802E - 4 English 8 | 2 | "Landlady" Questions | Jan 5, 2018 12:00:00 AM | 0.00 | Walls |
Doe, Jane | J832 - 9 Science 8 PreAP | 4b | Pressure and Hurricanes Canvas HW | Jan 8, 2018 12:00:00 AM | 0.00 | Niedens |
Smith, Kevin | J832 - 1 Science 8 PreAP | 8 | Pressure and Hurricanes Canvas HW | Jan 8, 2018 12:00:00 AM | 0.00 | Niedens |
Smith, Kevin | J811 - 9 Math 8 | 5b | ThrowBack Thursday HW | Jan 8, 2018 12:00:00 AM | M | Snyder |
Smith, Kevin | J811 - 9 Math 8 | 5b | Volume of Cones HW | Jan 8, 2018 12:00:00 AM | M | Snyder |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>