How to create contacts in AD

[wawen]

I need to create contacts for all the former students of a college.

I have an excel list of all the names. I have tried doing it manually but there are 500 names and I need to use an automated way to do this.

Please assist

[Shandain]

If you use powershell, you can download free tools from Quest Software (their ActiveRoles addons) that allow you to import CSV files and work with them in Active Directory.

[Shandain]

Even better... you can do it with the Exchange snapins....

 

$ou = ""

$DC = ""

$users = "File location"

 

import-csv $users | foreach {$last, $first, $mail = $_.last, $_.first, $_.mail new-mailcontact -name "$first $last" -ExternalEmailAddress "$Mail" -DomainController "$DC" -OrganizationalUnit "$OU"}

[Shandain]

I feel like I am babbling here now, but that is dependant on Exchange 2007 being your system of use... What mail system do you have?