Hello
I have played around with automatically sending emails to people through Access macros (with reports as attachments). However, I was wondering if I could do the following (and how).
I have a list of department heads and email addresses in a table. I also have a query that pulls employee salary and payroll information in another query (and report). If this report has to go to 180 individual people, I can hard code in the departments and the email addresses. However, creating the same report/macro 180 times seems inefficient.
Can I have access automatically look at the department on the report, reference the person's email address on the aforementioned table, and then blast out 180 reports to the different emails?
I would be very interested in what people have done here.
Thanks.
ps
I have played around with automatically sending emails to people through Access macros (with reports as attachments). However, I was wondering if I could do the following (and how).
I have a list of department heads and email addresses in a table. I also have a query that pulls employee salary and payroll information in another query (and report). If this report has to go to 180 individual people, I can hard code in the departments and the email addresses. However, creating the same report/macro 180 times seems inefficient.
Can I have access automatically look at the department on the report, reference the person's email address on the aforementioned table, and then blast out 180 reports to the different emails?
I would be very interested in what people have done here.
Thanks.
ps
