With this Add-in you can create a mail with only the activesheet attached as workbook or PDF, you can use variables in named ranges for the subject, body, To, CC, BCC and file name. You can use it for example to mail a invoice to a customer.
You can find the add-in on this page together with a few other example workbooks.
Will release a new version in Oct-2016
After you download the zip file you see that there are 3 files in it.
In Mac Excel 2016 we can't use all AppleScript anymore with the VBA MacScript function. we need to use a scriptfile in another location and call that with the new AppleScriptTask function. if you want to know more about the AppleScriptTask function read the information on this page : http://www.rondebruin.nl/mac/applescripttask.htm
Follow the stepes below to copy the RDBMacMailAddIn.scpt file in the correct location.
Note : If you have add one or both folders and have problems with the code on this page reboot your Mac first and test it again.
The add-in you can install with Tools>Excel Add-ins... in the menu bar. After you install the add-in you see a new tab on the Ribbon named RDBMail.
To test the add-in open the example workbook and you see that you have the option to create a mail with the activesheet as PDF or workbook on the RDBMail tab in the Ribbon. Also you can set the account and signature that you want to use. If needed you can delete the buttons on the sheet or make values of the formulas. You can save the variables if you want so it is easy the next time you want to use it.
In the example workbook there is information how to use named ranges to make it easy for you to get all the information in the mail. for example when you have a invoice with the mail address and subject in a worksheet cell.
If you got problems or have suggestions please let me know.
Download version 1.0 (4-Sept-2016)
Note: If you use macOS Sierra signatures are not working anymore, I am looking for a solution on this moment. To avoid errors you can disable one line in the scpt file.
Add two -- before this line : set message signature to defaultSig
if fieldValue8 is not equal to "" then set message signature to MessageSig else --set message signature to defaultSig end if
You can't use the signatures dropdown of the add-in in Sierra, hope to have a fix soon