Sending a basic e-mail in Outlook

When creating a large number of reports in Excel or Word using whatever tool you use the last thing you want is to have to send an e-mail telling everyone the report is ready or with it as an attachment. I have created a generic mail-list and function that I use to generate my reports but for the purposes of this I am just going to show how to send an e-mail. There will then be another post on how to send an HTML e-mail which can be great for sending summary tables with some nice formatting. 

First here is a screenshot of the end result: 

Here is the code: