Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Send Mail from Mac Excel

VBA code examples

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.

 

Mail from Excel 2016 with Apple Mail or Outlook 2016

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
Note
: please report if you have problems or have suggestions.(updated 25-11-2016)

Mail from Excel 2016 with Mac Mail example
Note
: please report if you have problems or have suggestions.

 

Check out this page for information about creating and mailing PDF files with 2016

 

Mail with Excel/Outlook 2011

 Note: on every page there is a link to a page with tips, please read them.

Last update Outlook examples 20-Aug-2013

Mail the whole workbook with Outlook 2011

Mail one Sheet With Outlook 2011

Mail more then one sheet with Outlook 2011

Mail Range or Selection with Outlook 2011

Mail every WorkSheet with address in A1 with Outlook 2011

Mail a row or rows to each person in a range with Outlook 2011

Mail worksheet in the body of the mail with Outlook 2011

 

Mail with Excel 2011/Apple Mail

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.

Mail the whole workbook with Apple Mail

Mail one Sheet With Apple Mail

Mail more then one sheet with Apple Mail

Mail Range or Selection with Apple Mail

Mail every WorkSheet with address in A1 with Apple Mail

Mail a row or rows to each person in a range with Apple Mail

 

Make and Mail PDF files with VBA code

Check out this page for information and a example workbooks for Excel 2011-2016.

 

Mail add-in for Excel 2011

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.