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 = "<Destination DN>"
$DC = "<FQDN of 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?