export outlook contacts to mac address book

Click File > Save, and then in the Save As dialog box, please: (1) Specify the destination folder you will save the workbook into (2) Name the new workbook in the File name box (3) Click the Save button. And you can delete the row of contacts as you need.ġ0. Select and copy the cell with contacts, right click a blank cell and select Transpose (T) from the right clicking menu.Īnd now all contact of the Global Address List are pasted into a column (See screenshot above). In the Convert Text to Columns Wizard – Step 2 of 3, please only check the Semicolon option, and click the Finish button.Īnd now all contacts of the Global Address List are pasted into a row in Excel.ĩ. In the Convert Text to Columns Wizard – Step 1 of 3, please check the Delimited option and click the Next button.Ĩ.

Keep selecting the cell, and click Data > Text to Columns.ħ. Now all contacts of the Global Address List are pasted into the selected cell in Excel.Ħ. Create a new workbook, right click a blank cell and select Keep Text Only in right-clicking menu. Please select all recipients in the To filed, right click and select Copy from the right-clicking menu. (3) Click the To -> button to add all contacts as email recipients.Ĥ. (2) Select all contacts with holding the Shift key and clicking the first contact and the last one (1) Select the Global Address List from the Address Book drop down list In the Select Names box, please (see screenshot below): Go to the new Message window, and click the To button in the message header.

Create a new email with clicking Home > New Email.Ģ. Updated December 2020: Updated for macOS Big Sur.Please follow below steps to export the Global Address List or an Address Book from Outlook to Excel.ġ. Questions about the process to back up Mac contacts? Be sure to check out our latest recommendations before making a decision. Looking for a new Mac?Īs Apple adds new Macs to its lineup, iMore adjusts our yearly recommendations.

Let me repeat that for clarity: when importing a dot-abbu package, there is no option to merge with your existing data.

If you try to open an '.abbu' package in the OS X Contacts app, it will ask you if you want to replace your current contacts database with contents of '.abbu'. The latter, however, will replace your entire contacts. Moving forward, the former, when imported, will allow you to merge information with an existing contact. The Export vCard choice only includes the selected contacts from the Contacts.app, while selecting Contacts Archive would include an export of all of your contacts. The main points are worth repeating here since the execution remains the same even as OS X became macOS later that year. In 2016, MacStories did a great job explaining the differences between saving contacts as a vCard or archive and how the choice you select could affect a future import.

Export outlook contacts to mac address book