how to import contacts into outlook 2014

If you wish to sync email, you will need to create an iCloud email address if you haven’t already. Check the “ Contacts, Calendars, and Tasks” option.Open iCloud on your Windows computer from “ Start” > “ All Apps” > “ iCloud” > “ iCloud“.Be sure to restart the computer after installation. Download and install iCloud on your Windows computer.From the iPhone or iPad, go to “ Settings” > “ iCloud” and ensure your iCloud account is setup and signed in.For information on backing up and restoring your Outlook Contacts and other data see the guide: Backup and Restore all Outlook data.With this option, you can sync Outlook with iCloud, and items will be synced to your device. Press CTRL+V to paste all contact information or use the Paste button on the Ribbon or on the Toolbar.(In Outlook 2007, you can also use Edit-> Copy) Press CTRL+C to copy your selected Contacts.(In Outlook 2007, you can also use Edit-> Select All) Press CTRL+A to select al your contacts.Press OK until all the open screens are closed.You can choose between even more fields by selecting “All Contact fields” from the “Select available columns from” dropdown list.

View-> Current View-> Customize Current View…-> button Fields… View-> click on the 3 dots on the right (…)-> Add Columns View-> group: Arrangement-> button Add Columns

Insert and arrange the columns you want to export to Excel.

Change your view to a table view like the “Phone List” view.

You can still achieve the same by exporting to the csv-format but that can be even more cumbersome.įortunately there is another, more graphical (WYSIWYG), way to do this as well via the copy/paste method. The export to Excel option has been removed from Outlook 2013 mainly because it was still using the old xls-format instead of the new xlsx-format. Although the Import and Export wizard allows you to export to an Excel spreadsheet, the Wizard doesn’t allow you to export all the fields and filtering the mapped fields is a cumbersome process as well.

How to import contacts into outlook 2014