I found this macro on Daniel B. Curran Jr.'s site.
This automatic email sending function is great for me, but a few things are missing:
1. The macro only works when a specific row is selected and the "send" button in the excel sheet is pressed. I would like to send emails automatically...