Create a shortcut to move files in Finder

This tip isn’t specifically for Microsoft Office but it is very useful for moving files we create with Office. This tip requires Snow Leopard and uses Automator.app that comes with OSX. I had trouble with the shortcut Command+Control+M conflicting so I changed mine to Command+Control+Option+M. (See screenshot below.) I also found that if you save to the root Services folder you’ll need to change permissions on the file. Saving to the User’s Library/Services works . . .

Continue Reading: Create a shortcut to move files in Finder

Manage Outlook contacts using AppleScript

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

Convert old Excel (.xls) files to standard (.xlsx) files

Mac MVP James Gordon has posted directions on how to convert old Excel (.xls) files to standard (.xlsx) files using Automator.

What does this converter do? You choose one (.xls) file, several (.xls) files, or an entire folder filled with (.xls) files and the converter will save a copy of each Excel file in standard open XML file format, better known as the “new” (actually more than 5 years old now) Excel (.xlsx) format. This . . .

Continue Reading: Convert old Excel (.xls) files to standard (.xlsx) files

Convert old PowerPoint (.ppt) files to standard (.pptx) files

Mac MVP James Gordon has posted directions on how to convert old (.ppt) files to standard (.pptx) files using an Automator workflow.

What does this converter do?

You choose one (.ppt) file, several (.ppt) files, or an entire folder filled with (.ppt) files and the converter will save a copy of each PowerPoint file in standard open XML file format, better known as the “new” (actually more than 5 years old now) PowerPoint (.pptx) format. . . .

Continue Reading: Convert old PowerPoint (.ppt) files to standard (.pptx) files

Convert old Word (.doc) files to standard (.docx) files

Mac MVP James Gordon has posted directions on how to convert old Word (.doc) files to (.docx) files using an Automator workflow.

What does this converter do?

You choose one (.doc) file, several (.doc) files, or an entire folder filled with (.doc) files and the converter will save a copy of each Word file in standard open XML file format, better known as the “new” (actually more than 5 years old now) Word (.docx) format. . . .

Continue Reading: Convert old Word (.doc) files to standard (.docx) files

Create a Service to attach files to a new Outlook for Mac mail message

Automator icon

Office 2011 has dozens of Automator actions to make scripting tasks possible without necessarily having to know AppleScript. Outlook for Mac alone has more than 20 actions that you can use individually or in combination with other actions. Let’s look at creating a very simple but useful workflow to attach messages to a new Outlook for Mac mail message.

First, launch the Automator.app application found in the /Applications folder. You’ll first be asked to choose . . .

Continue Reading: Create a Service to attach files to a new Outlook for Mac mail message

Create Service to “Add Attachment to new Entourage Message”

You can simply drag a file to the Entourage icon in the Dock to add as attachment to a new or existing message, but if you want to create a Service so you can control-click (right-click) on a file to add it as an attachment to a new Entourage message, Snow Leopard’s Automator makes it easy to do. . . .

Continue Reading: Create Service to “Add Attachment to new Entourage Message”

Backup Your Contacts

Learn to backup your Entourage contacts using several options. Set up an Automator workflow that can be scheduled to backup automatically. Manually export your data as .rge and tab-delimited files. Save a .csv files for uploading to an online Address Book. . . .

Continue Reading: Backup Your Contacts

Using Automator and Entourage to back up the MUD folder

In this article, you will find out how you can configure your Mac to create a backup copy of the Microsoft User Data folder whenever you quit Entourage. While there have been some stability improvements with the latest version of Entourage (Entourage 2008), it is always a wise decision to back up the Entourage database. There are a couple of solutions on the Entourage Help Page, and this method is in fact only an automatised version of telling the Finder to copy the MUD folder to a different location. At the same time, the automation might appeal to some users who would otherwise forget to back up their files, so let us have a look at how this process can be set up. . . .

Continue Reading: Using Automator and Entourage to back up the MUD folder

Backup Entourage

When losing your data is not an option, learn how to backup your Entourage data. . . .

Continue Reading: Backup Entourage