This tutorial will show you the code you need to be able to send an email from excel. this is really easy and onlly takes a little bit of code which is displayed below.
As you can see this is a very simple code and you can copy and use it for your spreadsheet. You will have to remember to change a few things though and they are the email subject, email send from address, the send to address, the Cc address if you have one if not you can remove it from your code and the email body. The other thing you might have to change (probably wont need to) is the email application you will be using I use outlook so you can see that I have typed in "Outlook.Application" next to set email_object this will make it use outlook to send the email.