This White Paper for VBA Developers demonstrates two methods to send Images by Email using VBA and Outlook. SendMail ensures that Images are Sent by Displaying the Message and letting Outlook embed the HTML Markup. SendMail2 uses the Outlook.PropertyAccessor to Attach and hide embedded Images referencing the modified HTML Markup for Images with a 'CID:' Tag. Both SendMail Subroutines use the Outlook Progress Dialog to force a Send & Receive in Outlook. Mail and MAPI Namespace Objects are invoked via Late Binding. The Default Mail Profile for Outlook on the Local Machine is used to send Email

The Examples demonstrate sending Email with a Default Signature, HTM Signatures and HTML Templates. They cover using Mailing Lists, using an Excel Range as a Body, Mailing the Workbook, Mailing individual Worksheets, Mailing the Workbook as a PDF File, changing the Importance or Sensitivity of an Email and changing the Formula in a Worksheet or Workbook to Values. Finally, the White Paper touches upon using Table Cells and Stylised HTML as an alternative to using Images

Microsoft Excel 2010-2013, Microsoft Outlook 2010 client and Microsoft Word must be installed on the Local Machine. Macros and access to the VBA Project Object Model must be allowed in Excel. Microsoft Outlook does not need to be running to use SendMail or SendMail2

Features include:
Send Email using the Default users Outlook Signature
Dynamically build a HTML Body with Social Icons using Web Links
Display an Email by Building a HTML Body using a String with an Excel Icon using Table Cells
Use a Dialog to Prompt for Multiple Attachments and Email the Attachments using a Default Signature
Force an Email to be Sent using Send & Receive
Send an Email with High Importance, Confidential Sensitivity & Request a Read Receipt using a Default Signature
Mail the Active Workbook using a Default Signature
Mail the Active Workbook as a PDF File using a Default Signature
Mail Sheet1 & Sheet2 as single .XLSX Workbook Report Attachments
Mail Sheet1 & Sheet2 as Separate Workbook Report Attachments (.XLSX & .XLSM)
Mail Sheet1 & Sheet3 as a Single PDF File using a Default Signature
Mail Sheet2 & Sheet3 as a Single Workbook as Special Values
Send an Email with an Excel Range as the Body together with a Default Signature
Send an Email with a Default Signature using Mailing Lists
Send an Email with a HTML Template containing Local Images
Get the Users Default Signature Name
Get all of the Users Signature Names
Get the Users Default Reply Message Signature Name from Microsoft Word
Using a Settings List to Send Mutiple Emails using a Default Signature
Read in HTML from a Template into a VBA Code Module
32 Subroutines accompany this White Paper

The main reason for writing this White Paper was to write Subroutines that I could use to Send Email with Signatures and Images via automation. Due to the way I have written the Code SendMail2 Subroutines make this possible - the Code can silently push out Email without Outlook even being open making it ideal for integration into automated Excel Workbooks whenever there is a requirement to Email out the finished Workbook

Use the links above to purchase SendMail or read online documentation and watch a video of SendMail on YouTube. You can also Share this article to Twitter, Facebook or Google+ using the links at the bottom of this page