Setting a group email in Access based on a flag in employee table

I have a table of employees in Access 2010.  I have a "yes/no" field in the table on a column called SendEmail.  I would like to create a VBA script that when executed will populate the employees email addresses of all the "yes" employees from the table into the Outlook "To" field.  Once the email is open, with the email addresses in the TO field, I would type the message I would like to send.  

Is there a script out there that will do this?
marku24Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
als315Connect With a Mentor Commented:
Look at sample
DBmail.accdb
0
 
marku24Author Commented:
great answer - easy and exactly what i was looking for
0
 
Dale FyeCommented:
Alexey,

Slow down!  You are kicking my butt today.  ;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.