How To Export Contacts Xls From Outlook For Mac 2016

In this Article: Article Summary On Outlook.com On Windows Desktop On Mac Community Q&A References This wikiHow teaches you how to download a file copy of your Outlook contacts. You can do this from the Outlook email website, or from within the Microsoft Outlook program. If moving from one Mac to another, transfer the.olm file to the new one. In Outlook for Mac 2016, on the Tools tab, choose Import. On the Tools tab, click Import. In the Import box, select Outlook for Mac archive file (.olm) > Continue. Import archive file as.olm. Locate the.olm file on your Mac, and then click Import.

Automator is an out-of-the box application that comes bundled with OS X. It first appeared in OSX 10.4 and has remained a very popular tool. With Automator, you can take any repetitive task and create a “workflow” script with simple drag and drop steps. Let’s run through an example using Automator to export contacts to Excel. Select Automator from the Applications menu. You are presented with a screen to choose what you want to automate. Choose Service and select Choose.

Select Service receives No Input in Any Application. Next, select Actions Contacts Find Contact Items and drag to the workflow.

Next, select Options and choose Show this action when the workflow runs check box. Now you are ready to drag Get Contact Information to the workflow. Next, change Export Format to Spreadsheet Tabs. NOTE: You can choose the contact information you want to appear in the Excel Contacts fields list. Or, you can just accept the default values.

Choose Utilities and drag the Copy to Clipboard to the workflow. Next, select Documents and drag Create New Excel Workbook to the workflow. At this point, we are almost done. Select Documents Paste Clipboard Contents into Excel Workbooks and drag into the workflow. Select File Save from the menu bar. Enter a name of the service you just coded / created. Ready, Set, Action 12.

Test your workflow by clicking the Run button. For example, choose Facebook.com and the automation will automatically place all users in your address book with an email address that contains Facebook.com in an Excel spreadsheet. Note: Do not forget that you can specify the fields you would like to import into Excel by specifying the Get Contact Information fields. Once you click Continue, all people in your address book that fit this criteria appear in Excel.

Because you saved this as a service, you can create a shortcut to run this automation whenever you need it. Select System Preference from the Apple Dock. Next select Keyboard and select Services. Select Add Shortcut on the far right and pick your shortcut. I chose Shift + Command+ 7. From within any application, choose your shortcut and it will run your automation.

Steam controller on mac for wizards of legends. As you can see, Automator is very powerful and you can automate many types of tasks with zero programming knowledge. As you work through this tutorial, continue exploring all the other options Automator has to offer.