Ok I have a table (table1) of student information and grades. Only fields I need to focus on are "Grade" and "School". I have a query that filters the grades (query1) but need help figuring out how to email 1 report to each school with list of students. I dont know how to call out data from a field and send email based off of the data. So if ASU has 20 students listed and I need to send email to ASU with that report, but in next...