how to import contacts into outlook from excel 2013

If you're using Access 2016, Access 2013, or Access 2010, on the External Data tab, in the Import & Link group, click the More button to drop down a list of options and then click Outlook Folder. If you're using the latest version of the Microsoft 365 subscription version of Access or Access 2019, on the External Data tab, in the Import & Link group, click New Data Source > From Other Sources > Outlook Folder. Choose the steps that match your Access version: The location of the import/link wizard differs slightly depending upon your version of Access. Changes made to the data in Access are reflected in Outlook, and vice versa. By contrast, if you use the link option, Access maintains a link to the Outlook data.

Changes made to the data in either program do not affect the data in the other program. If you import the data, Access creates a copy of the Outlook data and puts it in an Access table. You can use the Exchange/Outlook Wizard to import or link to Outlook contact data. Import or link to Outlook contacts by using the Exchange/Outlook Wizard As a result, you might want to import or link to contact data from Outlook into Access.įor more information about the reverse procedure (exporting contacts from Access to Outlook), see the article Export contacts to an Outlook address book. LessĪccess and Outlook are both excellent programs for managing your personal and business contacts. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.

How to import contacts into outlook from excel 2013