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?

[Webinar] Streamline your web hosting managementRegister Today

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
All Courses

From novice to tech pro — start learning today.