Mail from Mac Excel and Outlook 2016 and up
The script isn't selecting POP or IMAP its how the account is setup in outlook i.e. If i set an email account in outlook using POP3 the script work's and I get a new message in the drafts folder. Using IMAP the script runs with no errors but no new message appears. Apparently Outlook 2016 (Office 365) does not ship anymore with the handy Automater scripts that used to accompany Outlook. Using Applescript and Automator After searching around the internet for different options, I found out that using Applescript together with Automator is the easiest way to do this. Step 1 – Write Applescript to move selected Outlook item to Archive. Optional: Install a shortcut to the script editor in the Apple menu as follows. You have to be in the script editor first, then in the menu at the top. Step 2 – Assign the Applescript to a Service using Automator. Outlook 2016 for Mac no longer has a feature to download and update the Global Address book manually through the send/recieve settings. I have read through many forums and found the Offline Address book is updated once every 24 hours on mac clients but is there any way to initiate an address book update? Need help understanding why this Applescript works with Outlook 2011 for Mac but not Outlook 2016 or 2019 for Mac. Now when you compile and run the Applescript it will open the eml file and create a new reply message in window but the date in the header of the original message is as expected with the older date and time shown.
What is changed between Office 2011 and Office 2016 and up
The legacy 'MacScript' VB Command is severely limited by Apple’s sandbox requirements: it will not work correctly in most situations in Office 2016 and up. Updating the MacScript function seems to be too difficult.
Instead, Microsoft added a new VB command 'AppleScriptTask' that accesses and runs an AppleScript file located outside the sandboxed app. This new approach is not as convenient: with the MacScript function you could have the script in the file itself, while with the AppleScriptTask method you need to distribute an extra file containing the script, and it must be placed in the specified location on the user’s system to have permission to run. This requires some user interaction the first time.
See this page if you want to learn more : AppleScriptTask in Office 2016 and higher for the Mac
If you use Mac Mail check out this page : Mail from Mac Excel 2016 and up with Mac Mail
Examples to mail with Mac Outlook 2016 and up
Download examples, add-in and script file in Zip format (File date : 1-Feb-2019)
Important: There is a bug in 16.39 when you send the mail directly when you set displaymail to 'no', it is only working the first mail but the second and ? time not, they say they will update it in the next update.
Note : In the 1-Feb-2019 version there is also body html example workbook and also the add-in have this option, for this the script file is also changed. If you use a older version of the code you must not forget to replace the script file.
After you download the zip file you see 4 Excel workbooks, one add-in(version 4.0) and one script file, before we can test the code example we must copy the script file in the correct location of your Mac. You only have to do this one time. The example workbooks and the add-in use this script file, without it the examples and add-in will not work.
Note: If you use macOS Catalina replace the script file in the download above for this one : Catalina Script File
Where must I copy the file(RDBMacOutlook.scpt) with the script :
Open a Finder Window
Hold the Alt key when you press on Go in the Finder menu bar
Click on Library
Click on Application Scripts (if it exists; if not create this folder)
Click on com.microsoft.Excel (if it exists; if not create this folder) note: Capital letter E
Copy the script file from the download inside this folder
Test the code in the workbooks
You have download 4 workbooks, 3 of them have code examples in it so you can test. Be sure you are op to date, Look in the Excel Help menu for 'Check for updates'
MacOutlookWithExcel2016.xlsm to create a mail with the ActiveSheet, Selection or WorkBook
MacOutlookWithExcel2016PDF.xlsm to create a mail with the ActiveSheet, Range or WorkBook as PDF
MacOutlookWithExcel2016HTMLBody.xlsm to create a mail with the ActiveSheet/Selection in the body
You can use workbook 4 to test the add-in, see the next part on this page.
Add-in to send the activesheet as workbook or PDF
In the download you can find also a add-in (MacOutlook2016ActiveSheetAdd-in.xlam) and a example workbook(TestworkbookForMailAddIn.xlsx) that you can use to test the options in the add-in. Go to Tools>Add-ins to browse to the add-in and select it. After you have done this you will notice the new tab named RDBMailOutlook in the Ribbon.
Outlook For Mac 2016 Set Applescript To Run Windows 10
Please give feedback, good or bad. There is no object model for Outlook so it is trial and error to get things working in Mac Office 2016 and up.
Acknowledgements
Many thanks to Bastiaan Boertien(applescript specialist) for his help to get this working
Jan 28, 2017
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.
Outlook For Mac 2016 Set Applescript To Run Windows 10
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.
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.
Outlook For Mac 2016 Set Applescript To Run Windows 7
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.
Outlook For Mac 2016 Set Applescript To Run Command
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 Run 64-bit
Michael