import contacts to outlook 365 from excel

User Name: (or whatever your email address is).

Choose Manually configure server settings or additional service types. Type a name for your email account (example: Jakob), the email address (example: and password you use to sign in to your email account on the or web site. Now, add the email account back to Outlook on your desktop, but this time you're going to set it up as an IMAP account:Īt the top of Outlook on your desktop, choose File.

If it's the only account currently in Outlook on your desktop, choose File > Account Settings > Account Settings > Remove. For example, if you have more than one email account in Outlook 2010, you can right-click your selected email account and choose Remove to remove it from Outlook on your desktop. Here's how to configure your email account to use IMAP:įirst, remove your email account from Outlook on your desktop. If you are using an or account with Outlook and you get this error message, then the problem may be that your account needs to be set up as an IMAP account so you can import contacts to it. The error message 'Could not complete operation because the service provider does not support it' means there's something wrong with your Gmail account and you need to contact Google support for help. For example, let's say you have a Gmail account and you're using Outlook on your desktop to import contacts. There's a problem with your email account, and you need to call your email service for help.

Repeat the steps to import your contacts.csv file to Outlook. If you choose No, the file will get messed up and you'll need to start over with a new contacts.csv file. When you close the file, Excel will prompt you a few times with 'are you sure you want to save it in CSV format?' Always choose Yes. If you are exporting from Google, be sure to choose to export All contacts, or the right group of contacts.Īfter you export your contacts, use Excel to open the CSV file and check that there's data. In that case:Įxport your contacts from the source email system again. If there isn't any information in the CSV file, the export from source email system didn't work. Use Excel to open the CSV file you exported from the source email systemĬheck whether there is any information in the CSV file. If you exported contacts from Google, the default file name is contacts.csv. Locate the csv file you exported from your source email system, for example, from Google. If you complete the import process but no contacts appear in Outlook, do the following:

Import contacts to outlook 365 from excel