Chapter 9

Sending Emails from Excel

In This Chapter

arrow Emailing your workbooks as attachments

arrow Emailing specific sheets or ranges as attachments

arrow Sending emails to all addresses in your contact list

arrow 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.

remember 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.

You may noticed that I am not using the SendMail command native ...

Get Excel Macros For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.