VBA (Visual Basic for Applications) is the programming language used to create macros. A good knowledge of VBA can save time and make you a much more productive Excel user. VBA is a common programming language found in virtually all Microsoft Office applications. People will often learn VBA before progressing to other languages in due course.
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.