how to import contacts into outlook 2007 from excel

Click File > Export > Comma separated values (CSV).

Click Export Now, next to Microsoft Outlook.Select what contacts you want to export.If prompted for a security code, then enter it.From the toolbar, select Manage > Export.Map Custom Fields will customize how your contacts are exported (Outlook 2010 only).Select Contacts folder (if you have multiple then you need to do this for each one you want to export).If you don’t already have a CSV of your contacts (some email clients call it an address book, but it’s the same either way), here’s how you get it from most popular email systems and clients: Email From Office 365’s Outlook Web Access, go to your Contacts.Get your contacts into a CSV file, and then: Option 1: Use Import Contacts to Load Your Contacts From a CSV That is handled by the administrators as they move the mail and contacts for their users. This is beyond the scope of this article, but if you’re moving from an Exchange Server that is on site to Office 365 in the cloud, then you do not want to leave the importing of contacts up to the users. If you’re moving from an existing Exchange server (on-premises) to Office 365, then you’ll migrate the users through the PowerShell console.

Of course, if you’re an administrator or support professional, you’ll need to be able to teach others how to import their contacts.ĭepending on the system that you are importing your contacts from, there are several approaches to moving your contacts or address book into Office 365.

One of the first things you will want to do is import your contacts from other email accounts. With always on service and the ability to connect to your work email from anywhere, your productivity is sure to improve. If you’re a new user of Office 365, you may be excited at the ability to connect to your work email as easily as you’ve been connecting to your personal Hotmail account.

How to import contacts into outlook 2007 from excel