Emailing a variable number of records with Access

[Asril]

I am attempting to use Access to email a supervisor a list of employee timecards that were not completed on a daily basis. The list of supervisors being emailed can changeday to day along with the number of records to be emailed.

I am at a loss on how to get Access to send the appropriate names to the correct supervisor in a single email. The list might be one name or it might be 50. Is it possible to do this with a single query and let Access sort them out/email?

The current query that I am using pulls out timecards with a incomplete status and providers the supervisor name and email.

[Stang02GT]

I am attempting to use Access to email a supervisor a list of employee timecards that were not completed on a daily basis. The list of supervisors being emailed can changeday to day along with the number of records to be emailed.

I am at a loss on how to get Access to send the appropriate names to the correct supervisor in a single email. The list might be one name or it might be 50. Is it possible to do this with a single query and let Access sort them out/email?

The current query that I am using pulls out timecards with a incomplete status and providers the supervisor name and email.

I personally have a Access app that allows users to send e-mails but they are just blank e-mails, so im not exactly sure on how to do what you are asking but i can point you in the right direction check out this site i think you will find it very helpful!

Here is the site

Here is another good example


Good luck!

[Asril]

Thanks for the sites!

I ended up going with the one email per record approach. It might mean a supervisor will get 20 emails if he has 20 issues..but maybe that isn't such a bad thing. I will nag/spam them into compliance! :)