how to import contacts into outlook 2010 from csv

If you are providing this script to a non-administrator to use, you can configure an RBAC custom role to limit their permissions to only allow them to create contacts in a specific OU, as demonstrated here. You can also set a default OU for contacts in the script, or use the -OU parameter to specify an OU.ĭownload the script from the TechNet Gallery or GitHub.Įxample usage: C:ScriptsImportContacts>.Import-MailContactsFromCSV.ps1Ĭ:ScriptsImportContacts>.Import-MailContactsFromCSV.ps1 -CSVFileName externalcontractors.csvĬ:ScriptsImportContacts>.Import-MailContactsFromCSV.ps1 -OU '/Company/Contacts' This template file can then be used to successfully. csv file created by your e-mail program and paste it into the template file. csv file that will be used as a template.

To do this, first export your Outlook contacts into a. The script looks for a file named Contacts.csv by default, or you can use the optional -CSVFileName parameter to specify your own file name. csv file that uses the format expected by Outlook. Choose Outlook Data File (.pst) and click Next. Choose Import from another program or file and click Next. pst file: In Outlook, click File > Open & Export > Import/Export.

The current version of the script supports a CSV file containing the following fields, which are the minimum details required for creating a mail contact in Exchange: Here are the steps to import contacts into Outlook from a. Import-MailContactsFromCSV.ps1 is a PowerShell script to automate the creation of Exchange mail contacts using a CSV file for input.

How to import contacts into outlook 2010 from csv