DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2648667 - Last Review: October 6, 2014 - Revision: 11.0

On This Page

INTRODUCTION

This step-by-step article describes how to export contacts from Microsoft Outlook 2011 for Mac to Microsoft Exchange Online by using Microsoft Outlook Web App in a Microsoft Office 365 environment.

MORE INFORMATION

Scenario

A user sets up a profile in Outlook 2011 for Mac to connect to his or her Exchange Online mailbox in Office 365. However, external contacts aren't synced with Exchange Online. This occurs because external contacts must be exported from Outlook 2011 for Mac and then imported to Outlook Web App. However, the existing method to export contacts from Outlook 2011 for Mac is to use a text-delimited file, and this file type isn't supported in Office 365.

Procedure

To export contacts from Outlook 2011 for Mac to Exchange Online by using Outlook Web App, follow these steps.

Step 1: Export the contacts from Outlook 2011 for Mac

  1. In Outlook 2011 for Mac, on the File menu, click Export.
  2. In the Export Assistant, click Contacts to a list (tab-delimited text), and then click the right arrow button.

    Collapse this imageExpand this image
    A screen shot of the Export Assistant page, showing Contact to a list (tab-delimited text) is selected

  3. Click Done to finish.

    Collapse this imageExpand this image
    A screen shot of the Export Complete page
Notes
  • Tab-delimited files are saved with a .txt extension.
  • Contacts that are already associated with a Microsoft Exchange Server account or a directory services account aren't exported.

Step 2: Open the contacts by using Excel 2011 for Mac

  1. In Excel 2011 for Mac, on the File menu, click Open, and then select the .txt file that you created in step 1.
  2. In the Text Import Wizard, follow these steps. Be aware that in these next three steps, the default settings are used.
    1. Select Delimited as the file type, and then click Next.

      Collapse this imageExpand this image
      A screen shot of the Text Import Wizard, showing the delimited file type is selected

    2. Under Delimiter, click to select the Tab check box, and then click Next.

      Collapse this imageExpand this image
      A screen shot of the Text Import Wizard, showing the Tab check box is selected

    3. Under Column data format, select General, and then click Finish.

      Collapse this imageExpand this image
      A screen shot of the Text Import Wizard, showing the General is selected as column data format

Step 3: Export the contacts to a .csv file by using Excel 2011 for Mac

  1. In Excel 2011 for Mac, on the File menu, click Save As.
  2. In the Save As box, type a name for the file.
  3. On the Format pop-up menu, select MS-DOS Comma Separated (.csv), and then click Save.
  4. A dialog box appears that contains the following message:
    This workbook contains features that will not work or may be removed if you save it in the selected file format. Do you want to continue?
  5. Click Continue.

Step 4: Import the contacts to Outlook Web App

  1. In Outlook Web App, on the Options menu, click See All Options.
  2. On the right side, under Shortcuts to other things you can do, click Import your contacts from an existing e-mail account.
  3. Browse to the .csv file that you created in step 3, and then click Next.
  4. When you are finished, the contacts are displayed in the Contacts folder in Outlook Web App.

REFERENCES

For more information about how to import contacts, go to the following Microsoft website:
Import Contacts (http://help.outlook.com/en-us/140/ff797549.aspx?sl=1)
Still need help? Go to the Office 365 Community (http://community.office365.com/) website.

Applies to
  • Microsoft Exchange Online
Keywords: 
o365 o365a o365e o365p kbgraphxlink o365m o365022013 kbgraphic KB2648667
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support