Beta testing High Sierra with Office for Mac

Office for Mac 2016

If you are beta testing High Sierra with Office 2016, be sure to select Fast Insider updates under Help >Check for Updates in the Menu bar.

Office for Mac 2011 will no longer receive updates in October 2017. It will be an End of Life product. If you wish to continue using Office 2011 for Mac, do not upgrade to High Sierra.

Apple to Phase Out 32-Bit Mac Apps Starting in January 2018

Office 2011 for Mac is a 32-bit app. Starting in January of 2018, Apple will require all new Mac apps submitted to the Mac App Store to support 64-bit, and all existing apps must implement support by June of 2018. According to Apple, macOS High Sierra will be the last version of macOS that will support 32-bit apps “without compromise.”

Use AirDrop to share contact on phone with Outlook

If you have a contact on your iPhone that you want to add to Outlook on your Mac, try AirDrop

Share content with AirDrop from your iPhone, iPad, or iPod touch
With AirDrop, you can share photos, videos, websites, locations, and more with people nearby with an Apple device.



Archive old emails in Outlook to reduce size of Profile (Identity) using EagleFiler

As the years go buy a user’s Profile (Identity) gets larger and larger. I often see users with huge Profiles (Identities) 50GB and larger. Outlook has become sluggish under the weight of many GB of data. Not only is Outlook affected but on a small SSD drive, Outlook could be taking up the majority of space used. Consider this like a visit to your doctor. You can ignore the advice or wait until your Outlook Profile (Identity) has a fatal heart attack and you lose data.

EagleFiler will import all types of data, but we are going to focus on archiving your mail.

Download the demo for Eaglefiler

Let’s do some test imports so you can easily understand how to use EagleFiler before you make the plunge and start archiving. Continue reading Archive old emails in Outlook to reduce size of Profile (Identity) using EagleFiler

Right-to-Left (RTL) Support in Office for Mac 2016

Right-to-Left (RTL) Support has finally been added to Office for Mac 2016 in v15.20.  Currently v15.20 is only available to Office Insiders. If you can’t wait for the official release, opt in to join Office Insider. 

Office Insider builds for Mac are now available, you can opt in through Microsoft AutoUpdate. To access AutoUpdate, start an Office 2016 for Mac program, and then select Check for Updates on the Help menu.


Continue reading Right-to-Left (RTL) Support in Office for Mac 2016

Set Outlook 2016 for Mac as default email app

Thanks to sandboxing, there is no setting in Outlook 2016 for Mac Preferences to set Outlook as the default email app. You can read the Microsoft KB: Outlook 2016 for Mac cannot be set as the default application in Mac OS X Yosemite for details on why this option was removed.

To set Outlook as default, you have open Apple Mail > Preferences > General tab to set Outlook as default. However there is a slight hitch to using Mail to set Outlook as default. If you don’t have Mail setup to use an email account, you can’t access preferences. Continue reading Set Outlook 2016 for Mac as default email app

Use TextSoap to clean up text in Outlook for Mac

Entourage users will remember the option we had to clean up text using Auto Text Cleanup. Auto Text Cleanup was not included in Outlook. If you are replying or forwarding an email, you have to manually clean up the text.


You can replace Auto Text Cleanup with TextSoap. Not only does TextSoap work in Outlook, but all your applications. TextSoap v8.0 was just released with many new features. Check out the demo. I’ve used this great app for years and find it an invaluable tool.

  • Clean plain or rich text of unwanted formatting issues.
  • Create custom cleaners to match your specific text transformation needs.
  • Use batch file cleaning easily process a whole collection of files.

Continue reading Use TextSoap to clean up text in Outlook for Mac

How to quit Sync Services Agent

When you update Office 2011, you will have to quit Sync Services Agent and the Microsoft Database daemon. Some users are unable to quit these hidden processes. This article will cover several options to quit. If you are comfortable with using the Terminal option 6 has always worked for me.

Note: If you are trying to update an earlier version of Office 2011, you will need to quit all browsers in addition to the Microsoft Database daemon and SyncServicesAgent. (this requirement was removed in v 14.5) Continue reading How to quit Sync Services Agent

Click “Allow” or “Always Allow” to activate Office fails in El Capitan

Apple added new security in El Capitan (10.11.0) called System Integrity Protection (SIP). Adding to SIP, further changes to the Keychain in El Capitan 10.11.1 has resulted in problems selecting “Allow” or “Always Allow” for some users when trying to activate Office. The problem did not exist in previous versions of OS X. More info on SIP

Note: A recent Apple’s security update for Yosemite and Mavericks included the security fix that resulted in the issue reported in this article. (specifically CVE-2015-5943 )


Continue reading Click “Allow” or “Always Allow” to activate Office fails in El Capitan

Should you remove Office for Mac 2011 after installing Office for Mac 2016?

Users are asking if they should remove Office for Mac 2011 and their Outlook 2011 Identities after installing Office for Mac 2016.

You should not remove Office for Mac 2011 before updating to Office for Mac 2016. After you have successfully installed Office 2016 and imported all your data from Outlook 2011, you can select to remove or leave the old version.

  • Users with lots of free drive space, do not need to remove Office 2011.
  • Users on small SSD drives will most likely want to remove Office 2011.

Continue reading Should you remove Office for Mac 2011 after installing Office for Mac 2016?

AppleScriptTask in Office 2016 for the Mac

AppleScriptTask in Office 2016 for the Mac

In Office 2011 for the Mac there are many problems with the built-in VBA commands. For Example Dir, Kill, GetOpenFilename, GetSaveAsFileName and many others. For examplein Office 2011 file names in VBA are limited to a maximum of 32 characters including the extension. If the file name is longer the code fails.

VBA developers responded by using AppleScript in many situations to work around the problems. They also used AppleScript to do things that are not possible with VBA code; for example to email using VBA code, Excel 2011 and Outlook 2011.

In Office 2016, we need to use a new method and a new approach explained below.

Continue reading on Ron de Bruin’s Excel Automation site.