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 step send email to LSU with its report. I have this figured out the hard way with several queries by several I mean 4798 with 4789 reports and using macros to send the email this way sucks. Need it to pull list look at school the email that school with its list and continue down the list of schools until all schools are emailed. Any help with how to start would be a life saver. Thanks
Comment