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

Emailing a variable number of records with Access

P: 2
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.
Jul 24 '07 #1
Share this Question
Share on Google+
2 Replies


Stang02GT
Expert 100+
P: 1,208
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!
Jul 25 '07 #2

P: 2
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! :)
Jul 26 '07 #3

Post your reply

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