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?