I have an Access 2000 database that tracks employee performance review dates. The employee table houses the employee name, employee id, their Group Leader, and Team Leader. Another table houses their employee id and performance review dates.
The report shows employees, grouped by a combination of Group Leader and Team Leader, who are past due on their performance review dates. The report displays all the fields mentioned above and is built on a query.
What I would like to do is send an automatic email to any Group Leader or Team Leader whose name appears on that report when it is run. I toyed around with automated emails a bit and was able to create a macro that worked, but it would have required me to list every possible GL or TL name, thus they would all get the report. However, I only want to send an email to Team Leader Joe Smith if one of his employees, and thus Joe Smith's name, is on the report. If he's not on there one month, he shouldn't get an email.
Any recommendations on how to accomplish this?
The report shows employees, grouped by a combination of Group Leader and Team Leader, who are past due on their performance review dates. The report displays all the fields mentioned above and is built on a query.
What I would like to do is send an automatic email to any Group Leader or Team Leader whose name appears on that report when it is run. I toyed around with automated emails a bit and was able to create a macro that worked, but it would have required me to list every possible GL or TL name, thus they would all get the report. However, I only want to send an email to Team Leader Joe Smith if one of his employees, and thus Joe Smith's name, is on the report. If he's not on there one month, he shouldn't get an email.
Any recommendations on how to accomplish this?
Last edited:
