Automator workflow of the month: Export contacts to Excel

If you rely on Address Book to keep your contacts straight, you may be the tiniest bit disappointed that Apple’s contact management application provides so few useful ways to filter and export your contact data. Fortunately, Automator can lend a very helpful hand—particularly if you seek a way to filter your contacts and then export that filtered data to an Excel spreadsheet. Here are the steps for doing this.

Make your workflow

With a copy of Microsoft Office 2008 or 2011 on your Mac (these versions of Office install Word, Excel, and PowerPoint Automator actions), launch Automator and from the new workflow sheet that appears, select Service and click Choose.

Read more »

12

How to choose a to-do manager

Not too long ago, the main option for task management on the Mac was iCal’s To Do list. (Note I said option, not solution.) For serious task management, the Mac was a barren wasteland. Not anymore. Looking through the Mac and iOS App Stores, there seem to be more task management tools than fart apps. Those tools range from rudimentary checklists to gargantuan multi-feature, multi-platform systems. I know because I’ve tried a lot of them. For users, this newfound abundance of riches finally makes it possible for everybody to use their Macs (and iPhones and iPads) to manage their tasks and even, perhaps, get a little work done.

But while there are some software categories in which there is one clear best-in-breed solution, task management isn't one of them. Picking just one task manager as the best solution for everyone would assume that everybody has the exact same task management needs—which they don’t. The choice is different for everyone. Here’s how I made mine.

What I need

Read more »

23

Presenting with the iPad

You can give impressive presentations from your iPad‚ and perhaps even leave your laptop behind‚ if you prepare well and know what to expect. It's even easier to take to the podium with newer technologies like AirPlay mirroring and the latest version of Keynote for iOS. Here are tips for moving presentations onto your iPad and delivering them live.

Get it together

Apple’s $10 Keynote for iOS ( ) can import presentations made in Microsoft PowerPoint ( ) or in Keynote for OS X ( ), but in both cases you’re likely to lose a great deal during the import process. Say goodbye to some fonts, transitions, and builds that aren’t available on the iPad, plus audio and more. (Presenter notes are supported, however, whether created on the iPad or imported from a PowerPoint or Keynote for Mac presentation.) Therefore, when feasible, create your presentation directly on the iPad.

Read more »

21

Three great folder actions

OS X’s Folder Actions let you attach AppleScripts to specific folders so actions are performed automatically as soon as you add items to the folders. Once you know the basics of how Folder Actions work, you’ll inevitably start wondering what cool things they can do for you. Here are three interesting Folder Actions to try out.

1. Print files automatically

As much as you may dream of a paperless office, you may still receive documents you need to print. If you only have a single printer, and don’t need to tweak settings for different types of documents, you can create a Folder Action that will automatically print any files you add to a folder.

Read more »

8

Automate tasks with Folder Actions

One of the great things about OS X is that it’s like the real world. You store your files in folders; when you don’t want something, you put it in the Trash. But on your Mac, a folder isn’t really just a folder, and that’s not a bad thing. Take for example, Folder Actions. With this handy feature, you can attach AppleScripts to specific folders and have these scripts run automatically whenever you add files to the folders. That means that you can automatically get an alert when files are added to a specific folder, change the Finder labels when you put them in a folder, or unzip archives. Here’s how Folder Actions work, and how you can use them to save time.

Turn on Folder Actions globally

To use Folder Actions, you must first turn this feature on globally. To do this, right-click or Control-click on any folder and choose Services -> Folder Actions Setup. (If you only have a few Services, you may not have a Services menu and will instead see the Folder Actions Setup menu item at the bottom of the contextual menu.) When you choose Folder Actions Setup, a small window opens showing a list of AppleScripts. Select Enable Folder Actions in the window and then quit (Command-Q).

Read more »

7