There are several ways to send e-mail from Excel using Microsoft Outlook. It is possible to use the built-in function ActiveWorkbook.SendMail. However, it only allows simple e-mails to be created, and there is no way to add attachments. In this example we are going to use the COM library of Microsoft Outlook to get more control. […]