Chapter 9
Sending Emails from Excel
In This Chapter
Emailing your workbooks as attachments
Emailing specific sheets or ranges as attachments
Sending emails to all addresses in your contact list
Saving email attachments to a specified folder
Did you know that you probably integrate Excel and Outlook all the time? It’s true. If you've sent or received an Excel workbook through Outlook, you’ve integrated the two programs; albeit manually. In this chapter, I show you a few examples of how you can integrate Excel and Outlook in a more automated fashion.
The macros in this chapter automate Microsoft Outlook. For these macros to work, Microsoft Outlook must be installed on your system.
Mailing the Active Workbook as an Attachment
The most fundamental Outlook task you can perform through automation is sending an email. In the sample code in this section, the active workbook is sent to two email recipients as an attachment.
Get Excel Macros For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
