Because there are a few bugs in VBA SendMail in Excel for the Mac and there is no Outlook object model in Outlook 2011 and 2016 like there is in Outlook for Windows we Run a AppleScript string with the built-in VBA MacScript function in the mail examples below for 2011 to get the same or better result. In Excel 2016 we not use the VBA MacScript function anymore, read more about this on the example pages for Excel 2016. Note: There are code examples for Apple Mail and Outlook.
Note: If you are a Windows Excel user visit this index page.
Note: Microsoft not make it easy to mail with code in Mac Excel 2016, When I am sure that there will be no changes anymore I will add more mail examples for Mac Excel 2016. Please test and report problems or give suggestions.Mail from Mac Excel 2016 with Outlook 2016 examples
Check out this page for information about creating and mailing PDF files with 2016
Note: on every page there is a link to a page with tips, please read them.
Last update Outlook examples 20-Aug-2013
Last update 9-Oct-2016 : fixed attachment bug in El Capitan with Apple Mail and add a option to add more mail addresses in the To, CC and BCC. It also add the default signature now, please read the text above the functions about the problems with signatures in Sierra on this moment.
Check out this page for information and a example workbooks for Excel 2011-2016.
Tip: Mail Add-In for Excel 2011 for the Mac:
Mail Add-in for Excel 2011 with Outlook 2011 or Apple Mail
Will update the add-in when I have time and add the download link back, there are a few problems with the new Mac OS.