By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,656 Members | 1,893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,656 IT Pros & Developers. It's quick & easy.

Emailing Reports based on data from specific field

P: 1
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
Dec 20 '11 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,421
The steps would be
1) Create a recordset with each school and its e-mail address.
2) Loop through each record.
3) Send the report filtered by the school to the e-mail address.
Dec 20 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.