• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4245
  • Last Modified:

How do you create mail enabled contacts from csvde?

I exported users from one domain into a csv file.  I then modified the csv to import it into another domain as contacts.  What format do you need to import a user as a mail enable contact?

A sample of the csv file I currently have is shown below:

"CN=Gray\\, Eric ,OU=Embarkable,DC=cool,DC=com",contact,"Gray, Eric",eric.gray@cool.com,smtp:,smtp:eric.gray@cool.com
"CN=Jim\\, Aleyda M. OU=Embarkable,DC=cool,DC=com",contact,"Salinas, Jim M." ,aleyda.jim@cool.com,smtp:,smtp:aleyda.jim@cool.com
"CN=amy.buchs,OU=Embarkable,DC=cool,DC=com",contact,"Buchs, Amy J ",amy.buchs@cool.com,smtp:,smtp:amy.buchs@cool.com

  • 2
1 Solution
Zuhir ElgmatiApplications and Systems AdministratorCommented:
necromiserInformation System Security ManagerAuthor Commented:
The microsoft knowledge base does not show me which object to use to establish a email enabled contact through a csv file.
Excerpted from

Bulk contact import to AD using CSVDE

If you are just creating mail-enabled contacts, here is the format for the minimal amount of information for a test user into the OU Domain.com\Distribution\Categories:
contact,Aaron Adams,"CN=Aaron Adams,OU=Category,OU=Distribution,DC=Domain,DC=com",aadams,SMTP:aadams@domain.com,SMTP:aadams@domain.com,{26491CFC-9E50-4857-861B-0CB8DF22B5D7},aadams@domain.com

Copy all of the text between the lines and paste it into Excel (you may have to separate out the columns manually). There are two rows - first is the HEADERS which defines the attributes we are importing; second is the actual data. (You can paste into a text editor like Notepad or Word if you want to do a lot of manual work!) Excel will allow you to create formulas and "fill down" so you only have to put in the name and e-mail once and it will generate the other columns for you. Using this template, you can modify the values for your environment and put in all the users, then save as a CSV file and import it into Active Directory using "CSVDE -I -F IMPORT.CSV".

If you want to see the exact DN you need, based on your domain, dump all of your existing contacts using the following command (typed as one line):
CSVDE -F CONTACTS.CSV -R "(objectclass=contact)" -L objectClass,displayName,DN,mailNickname,targetAddress,proxyAddresses,msExchPoliciesExcluded,mail

That weird looking value for the import "{26491CFC...}" means "remove the checkbox to automatically update e-mail address based on recipient policy" on the e-mail address tab for the object.
necromiserInformation System Security ManagerAuthor Commented:
Thank you!  That was exactly what I was looking for.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now