Get the Lowest Prices anywhere on Macs, iPads and Apple Watches: Apple Price Guides updated October 15th


Road to Office 2011: New looks, support for Exchange, VBA

What's new: Exchange support in a revamped Outlook client

Microsoft is also finally getting around to adding better Exchange support to Office, ditching its Entourage app for an entirely new Outlook, which has been missing on the Mac for over a decade.

The original Outlook for Mac client used Microsoft's proprietary MAPI to talk to Exchange Server, just like the Windows version of Outlook. The problem was that MAPI is a mess of insecure RPC that was largely tied to Windows APIs, making it impossibly difficult to deliver cross platform while keeping features in parity and security in check. MAPI is essentially impossible for third parties to implement, and complex enough that even Microsoft didn't want to support it on its own Mac client.

In 2000, Microsoft decided to drop Outlook for Mac (which was a stagnating Classic Mac OS app) and start over with a native Carbon app that used Internet standard POP and IMAP. (Entourage was largely based upon Outlook Express for Mac, which itself was based upon Apple's Claris Emailer, through a migration of developer talent that flowed from Apple to Microsoft). The problem with Entourage was that many of the features of Exchange Server are not available using the standard IMAP protocol for Internet email. Additionally, Microsoft has recently started turning IMAP off by default on Exchange.

Microsoft worked to address this issue by giving Entourage support for accessing calendar and contact information via WebDAV, the same mechanism it had developed to enable Outlook Web Access and Windows Mobile devices to remotely access Exchange. However, WebDAV does not support some advanced features of Exchange and does not deliver great performance. Microsoft has since deprecated WebDAV as a way to connect to Exchange.

Starting with Exchange 2007, Microsoft moved a step away from both the old MAPI and WebDAV to introduce Exchange Web Services, which enable clients to communicate with Exchange via more conventional XML and SOAP. EWS is the technology Apple added in Snow Leopard to enable Mac OS X apps to work with Exchange. Previously, Mail, Contacts, and Calendar used WebDAV, which didn't work as well, nor as effeciently.

EWS still isn't on the level of MAPI (used by Outlook for Windows), but it does work pretty well. It's trailing in features such as support for Public Folders (something Microsoft has depreciated, but that many Exchange Server shops still use), delegation features, support for an "online mode" for only syncing recent items, or the use of "distribution group" contacts.

The new Outlook for Mac in Office 2011 appears to use EWS, just like Apple's Snow Leopard apps. Entourage originally used WebDAV, which was terribly slow. Microsoft has since patched it to make use of EWS, so the differences between Entourage and the new Outlook may not be as Earth shattering as some users might hope.

The new Outlook app is written from scratch as a new Cocoa app, so it does offer some advantages over Entourage in terms of having a streamlined user interface that works more like a Mac app, rather than being an ancient Carbon app rewarmed to feel slightly more native, as the rest of the Office suite is.

Notably, its Toolbar now works like a standard Mac OS X app with drag and drop customization, rather than the oddball toolbar-like strips Office uses, which are customized using a non-standard interface. Additionally, the new Outlook for Mac will enable users to migrate their Windows .PST files (containing their locally stored mailboxes) to the Mac, which Entourage has not previously been able to import.

Overall, Office 2011 is currently about 40% larger than Office 2008. The new Cocoa-based Outlook is about the same amount larger than the Carbon-based Entourage app it replaces (the beta 2 installer continues to refer to Outlook at Entourage, although it does actually install the new Outlook app).

 Office 2011 for Mac installer size

What's new: VBA support

In addition to the revamped Outlook, Office 2011 apps will also again support VBA macros, something Microsoft dropped while bringing Office 2008 to market. A the time, Microsoft said the feature was not very important to most Mac users, and that its removal was largely prompted by the necessity to make Office 2008 a Universal Binary supporting Intel Macs.

Microsoft explained that "the Macintosh VBA compiler [of the legacy Office code base] was originally designed for a much earlier PowerPC-based Macintosh and will not work, without significant modifications, on the Intel-based Macintosh. VBA macro code is compiled at runtime, and the compiler code, VB editor code, and VB forms code could not be converted for the Intel-based Macintosh without extensive programming work that would have significantly delayed the universal version of Office 2008.

"The Microsoft Office for Windows version of VBA can't be directly used for Office 2008 because it depends on execution of Windows machine assembly, which isn't compatible with the Mac OS."

Microsoft recommended that users affected by the change investigate using AppleScript as an alternative way to automate their document workflows. "The people most affected by the loss of VBA are those who need cross-platform programmability for Office," Microsoft said. Those people should now be happy to see VBA returning in the 2011 version of Office.

Office 2011 for Mac VBA

Other articles in this series:
Road to Microsoft Office 2011 for Mac: A New Hope

For those readers interested in the history of Office on the Mac, please see the first segment of AppleInsider's Road to Mac Office 2008 series.