Hello, I want to mail merge over 1000 records. In excel, I have columns for principal names, principal emails, individualized links, districts, school names, sde contact, and status (complete/incomplete) and so on. In the mail merge, I want to create a table for all completed responses from principals. That table would their name, email, and link. In another table, I want to list principals who didn't have a response (incomplete). This table would have the name and school listed. These two tables will be sent to one sde contact. One email per SDE contact. Each SDE contact will get a list of principals who completed/or did not complete the survey. I know how to do a basic mail merge but don't know how to set this up.

The email would like something like this:
Dear SDE contact,

Good morning. Our office has been working to collect individualized messages for the 2017 report card for <District>.



We have not received responses from:
Name Email Individualized Link




We have received responses from:
1. Name, School
2. Name, School
3. Name, School