You can use Excel to send emails from VBA. Using Excel VBA we can send an email containing our Excel file as an attachment to an email address we specify.
With five lines we can automate the process of sending our active Excel workbook to an email address. Simply copy the code below, and paste it into a new module.
Subject:="Email from Excel Geek"
Easy as that to send an email using VBA.
Nice short simple post. I hope you found it useful!