80s toys - Atari. I still have
HomeBlogAbout Me

Outlook For Mac 2016 Applescript



This only happens in Outlook 2016 and 2019. Outlook 2011 keeps the original date and time. Test 1 using Outlook 2016 or 2019. Create a simple email in Outlook with subject as test, body as test, and to address to yourself. Send the message, if used yourself the message should come into your inbox as a new message. I don't have Outlook 2016, but I see lots of posts on the Internet indicating that it still supports AppleScript, but the Outlook script menu/icon has been removed. Here's one example: Creating a task from email in outlook 2016.

  1. Outlook 2016 For Mac Update
-->

Original KB number: 4484206

Symptoms

When you try to send email messages in Outlook 2016 for Mac, the email messages remain stuck in the Outbox folder, and you receive the following error message:

Unexpected data was encountered.

Cause

This issue occurs because Outlook 2016 for Mac can't locate and use the Sent Items folder. The folder hierarchy in the mailbox may have become corrupted.

For example, in some cases, the Sent Items folder is converted into the Archive folder, and the icons that mark the two folders are incorrect. See the following screenshots:

A working accountA non-working account


Resolution

To resolve this issue, reset or rename the Outlook folders by using Outlook for Windows.

Method 1: Use the /resetfolders switch

Use the /resetfolders switch to restore the missing folders at the default delivery location. To do this, follow these steps:

  1. Exit Outlook.

  2. Open the Run dialog box: Ubar 4 0 3.

    • In Windows 10, Windows 8.1, and Windows 8, press Windows logo key +R.
    • In Windows 7 and Windows Vista, select Start > All Programs > Accessories > Run.
  3. In the Run dialog box, enter the following command, and then click OK:

Method 2: Use Outlook Web App

Use Outlook Web App to reset the default folder names. To do this, follow these steps:

  1. Exit Outlook.
  2. Sign in to Outlook Web App by using your credentials.
  3. Select Settings (the gear icon on the right) > Options > General (expand the list in the navigation pane) > Region and time zone.
  4. On the Regional and time zone settings page, change the language, select the date and time format that you want to use, select the Rename default folders so their names match the specified language option, and then select Save.
  5. Exit Outlook Web App.

    Note

    If your preferred language is already selected, you may have to select any other language, save the setting, reset the setting to your preferred language, and then save the setting again.

  6. Restart Outlook.

Method 3: Use the Set-MailboxRegionalConfiguration cmdlet

If you're an administrator, run the following cmdlet to reset the default folder names for the user:

For more information about language codes and the Set-MailboxRegionalConfiguration cmdlet, see the following websites:

Method 4: Use Outlook to select a new Archive folder

To do this, follow these steps:

  1. Download and install MFCMAPI.

    Note

    The x86-based version of MFCMAPI should be used with the x86-based version of Office, and the x64-based version of MFCMAPI should be used with the x64-based version of Office.

  2. Right-click the mailbox name at the top of the folder hierarchy in Outlook, select New Folder, and then create a folder that's named Archive01.
  3. Start MFCMAPI in Online mode. To make sure that MFCMAPI is in Online mode, select Tools > Options, and then make sure that the Use the MDB_ONLINE flag and Use the MAPI_NO_CACHE check boxes are selected.
  4. Expand Root Container > Top of Information Store.
  5. Copy the default input ID from the Inbox folder (the renamed Archive folder in this case). To do this, click the Archive folder, select the InternalSchema.ArchiveFolderEntryId (0x35ffXXXX) tag, right-click this tag, select Open Entry ID, and then copy the whole ID.
  6. Select the Archive01 folder that you created, and then examine the item. The following details are displayed:
    • Tag: 0x0FFF0102
    • Type: PT_BINARY
    • Name (s) of property: PR_ENTRYID, PR_MEMBER_ENTRYID, PidTagEntryId, PidTagMemberEntryId, ptagEntryId
    • DASL: http://schemas.microsoft.com/mapi/proptag/0x0FFF0102
  7. Delete the input ID, and then paste the ID that you copied in step 5.
  8. Close MFCMAPI.
  9. Run Outlook.exe /resetfolders.
  10. Run Outlook.exe /resetfoldernames.

For more information, see Folder names are incorrect or displayed in an incorrect language in Outlook. Things 3 3 – elegant personal task management training.

Third-party information disclaimer

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

Mail from Mac Excel and Outlook 2016 and up

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.

Microfit 4.1 software, free download. 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. X mirage crack pc game.

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

Mac

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.

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

Outlook 2016 For Mac Update

Many thanks to Bastiaan Boertien(applescript specialist) for his help to get this working





Outlook For Mac 2016 Applescript
Back to posts
This post has no comments - be the first one!

UNDER MAINTENANCE