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 example, in 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 . . .
Continue Reading: AppleScriptTask in Office 2016 for the Mac
Microsoft released Outlook for Mac 15, departing from its history of bundling the application with its Office for Mac suite. Also new was that the release was targeted exclusively at Office 365 customers and not made available as a standalone product. It required activation via online subscription and offered no method for entering a serial number for perpetual use of the product.
The application was referenced in Office Blogs simply as “Outlook for Mac”. It . . .
Continue Reading: Microsoft revamps features for Outlook for Mac 15
In an earlier blog post I provided an undocumented tip for quickly scrolling to a date in Outlook for Mac’s Calendar. Now, using the following AppleScript a user can navigate instantly to a specific date.
. . .
Continue Reading: Use AppleScript to instantly view a date in Outlook for Mac’s Calendar
Working with formatted text copied from a stylized source such as a web page can make editing in Word for Mac laborious. For someone who does it frequently, selecting Edit > Paste Special, choosing Unformatted Text and clicking the OK button is a lengthy mundane process. This command has no quick keyboard shortcut and Apple’s feature to assign a keyboard shortcut won’t work because the command isn’t in a menu.
Fellow MVP Rich Michaels recently . . .
Continue Reading: Use AppleScript or VBA to paste unformatted text in Word for Mac
Two weeks ago I posted an undocumented tip for quickly scrolling to a specific date from the Microsoft Answers forum. Today, another forum poster provided a great undocumented tip for using the keyboard to quickly delete unwanted email addresses from most recently used (MRU) list.
As Outlook for Mac sends and receives mail it stores the most recently used 200 email addresses in the MRU. You see the MRU at work every time you address . . .
Continue Reading: Undocumented tip: Use the keyboard to delete unwanted recent addresses
Update: Beginning with the Office for Mac 14.2.0 Update (SP2) Microsoft added week numbers to Outlook for Mac. Enable them first under Outlook menu –> Preferences… –> Calendar. They appear in either Week or Work week view next to the date range above the calendar.
Three years ago I posted a script to add week numbers to Entourage. I’ve updated that script for Outlook for Mac and made some improvements based on the comments I . . .
Continue Reading: Add week numbers to Outlook for Mac’s calendar
I am moving to Outlook 2011 from Entourage 2008. A bunch of my calendar items have reminders that are more than 2 weeks in advance, because in Entourage I could specify however many days I wanted. But in Outlook, there is only a dropdown menu and it only goes to 2 weeks. Is there any way to specify more than 2 weeks, and if not, does it still properly understand how (when) to . . .
Continue Reading: From the Outlook forum: ‘More than 2 week reminders?’
Yesterday, Microsoft released the Microsoft Office 2011 for Mac SP1 (14.1.0) Update. Outlook garnered a fair number of bug fixes and new features, some of which had been missing since Entourage. Under the hood it received a healthy dose of new commands, classes and properties in its AppleScript dictionary as well.
Compared to Excel, PowerPoint and Word, the amount of additional AppleScript support added with the 14.1.0 update is more than ten-fold their combined total, . . .
Continue Reading: Microsoft updates AppleScript dictionary for Outlook 2011 SP1
Our contacts often share the same information. For example, we may know two or more people who work for the same company and share the same address, phone number and website. Invariably, as we add contacts, though, we sometimes enter slightly different information for each one. The first contact record may list a company name of “Microsoft” while a second lists “Microsoft Corporation”.
Using Outlook’s AppleScript capabilities, we can standardize this information in our contacts. . . .
Continue Reading: Manage Outlook contacts using AppleScript