Comments on: Powershell to create contacts in Exchange 2007 from the given CSV

By: jamie

jamie — Mon, 11 Jun 2012 19:34:02 +0000

csv must be like this:
Displayname,EmailAddress,Alias
Krishna kumar,krishna.k@domain.com,Krishna.k

By: Pete

Pete — Sun, 17 Jul 2011 02:40:16 +0000

hi here the deal
i want to create a contact in a specifict place i have live 100 contcts to create and i got an excel sheet with first name, surname emial address and the country
how can i acheive this in exchange 2007 ?

By: Krishna - MVP

Krishna - MVP — Fri, 10 Dec 2010 19:55:50 +0000

Can you please send the exact error what you are seeing ?

By: Rusty

Rusty — Fri, 10 Dec 2010 01:49:46 +0000

when i run the script i get Unexpected token ‘in’ in expression or statement. any thoughts

By: Krishna

Krishna — Mon, 06 Jul 2009 10:20:43 +0000

Hello Rickb,

Thanks for the post

you need to have CSV in the below mentioned format in the contacts.csv

Display name,EmailAddress,Alias

Krishna kumar,krishna.k@domain.com,Krishna.k

Below code will read csv file one by one and create the contact in the OU users.

$csv = Import-Csv “C:\Contacts.csv”
foreach($line in $csv)
{
New-MailContact -Name $line.DisplayName -ExternalEmailAddress $line.EmailAddress -OrganizationalUnit “users” -Alias $line.Alias
}

By: Rickb

Rickb — Mon, 06 Jul 2009 05:52:00 +0000

Hi,

Can you post an example of the CVS format please.

Many thanks,

Rickb.

rick.bone@datacom.com.au