Macro Code to Send Email if Cell Value is 'True', to recipient located in same row.

Hi,

So I have a worksheet where a list of emails are located in column C, and there are checkboxes (or could be true/false value if it makes it easier) in column T.

What I am trying to do is have an email sent when the checkbox is checked (or value is changed to 'True') to the email address that is located in the same row of that checkbox/true value. All of the emails would be identical, just always sent to the recipient corresponding to the same row where the box was checked/value changed to true.

Thanks in advanced.


Matt

.
You can edit this project to fit your needs. Change the column locations for the various bits of data and then make edits in the code to match.

Please Login or Register  to view this content.

Hi!

This is great! I could make this work. Is there a way to have it send the email as soon as the value is entered. So, for instance, As soon as I place the "X" in Column A, the email is automatically sent to that recipient? Without needing to press the button.

The reason for this is that basically this will send an email to the recipient letting them know that their order is ready to pick up. But using this code I would need to remove the value from the cell after the email is sent or else each recipient will get repeated emails whenever I press the Button as long as there is still a value in the corresponding cell.

Thanks in advanced.

Matt

.
Here is a different version that is not automatic and allows you to clear the "to send" list so they are not receiving duplicate emails. Again, you will need to adjust the sheet and code to match your requirements.
This version also allows you to attach a document to an email if so desired.

Please Login or Register  to view this content.