25. VBA Tips - Email Workbook
There's an easy way to email a workbook with a single line of code:
- Use "Activeworkook.SendMail"
Here's the code:
Here's the email it produces:
- SendMail accepts 3 parameters... Recipients, Subject, and whether you want a read receipt.
- Note: You cannot add a body to the mail... this is a quick and limited way of emailing the workbook.
Training Video on how to Email Workbook in Excel: