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