Check out this:

http://www.makeuseof.com/tag/send-emails-excel-vba/

Lots more info can be found by googling "send email from Excel"