Here is a way in Outlook 2016 on Mac to do the equivalent of Windows 'Write a VB script and assign it to a key'. Thanks to those who pointed me in the right direction. On Mac this is done with Applescript, Automator, and Keyboard Shortcuts. I'm including the Applescript here that moves selected Outlook emails to an archive folder. The following AppleScript will trigger the script warning message when run in 15.21.1 but not in 15.19. Set theRecipient to '. Email address is removed for privacy. ' set theSubject to 'Test Message' set theContent to 'Outlook Mac Test' tell application 'Microsoft Outlook' activate.

1. Outlook For Mac 2016 Set Applescript To Run Windows 10
2. Outlook For Mac 2016 Set Applescript To Run 64-bit
3. Outlook For Mac 2016 Set Applescript To Run 64-bit
4. Outlook For Mac 2016 Set Applescript To Running

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 and up

Note: Microsoft not make it easy to mail with code in Mac Excel 2016 and up, When I am sure that there will be no changes anymore I will add more mail examples. Please test and report problems or give suggestions.

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

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

Outlook For Mac 2016 Set Applescript To Run Windows 10

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 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 more then one sheet 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.

Jan 28, 2017

Outlook For Mac 2016 Set Applescript To Run 64-bit

I recently updated my Mac to OS X Sierra and decided to test the AppleScript in Outlook Mac 2016, the script that converts e-mails to tasks. I had to reinstall it, but it is definitely working now. I placed my updated instructions for getting it installed at the old article about this capability, at this link.

History on This (In case Interested)

When Outlook for Mac 2011 was released in 2010, it shipped with an AppleScript installed that converted e-mails to tasks. It was (and still is) the only way to convert e-mails to tasks on the Mac version of Outlook. The drag and drop functionality of Windows Outlook is not present on the Mac. Using the script does not pick up attachments, but otherwise seems to work.

Outlook For Mac 2016 Set Applescript To Run 64-bit

In 2011, Microsoft stopped delivering that script with most Outlook for Mac installs. But if you copied the script from somewhere else and installed it in the right script folder, it would work.

Then in 2014 I think it was (I cannot remember), with an OS X update, all script capabilities on Outlook were blocked “for security reasons.” In the years after that some people were able to hack it in, but we didn’t support that.

So it’s good to see that the capability is back. Again, instructions for getting it installed are at my old article about this capability at this link.

Outlook For Mac 2016 Set Applescript To Running

Michael