VBA: Send Email
A couple links for sending email via VBA:
Different Ways to Take Advantage of the E-mail Features of Excel – Knowledge Base Article
DataPig Video Tutorial – Just a few lines of code.
Andrew on Excel and Email – Code to Email the Active Sheet and Active Book