Export exchange contacts to .csv file

Hello all,

I run exchange 2010 on a server 2008r2 blade server.  I'm trying to export contacts from outlook 2007 to a .csv file.  After I do the export when I open the .csv file all the contacts that were on our exchange server show up like this in the email column:


in the E-mail display column of the .csv file it shows this:

some one (someone@wherever.xx.xx)

The email in brackets is the correct email address.  I could manually go through each .csv file and fix things but I have around 50 users with hundreds of contacts each for so that's not really an option I like.  Is there a way I can export to a .csv where the exchange accounts have the proper emails in the email column?
Who is Participating?
KimputerConnect With a Mentor Commented:
In this case, I would suggest to use notepad to edit the source cvs file. First in Excel delete the garbage email column, then after saving it, open it in Notepad, replace " (" with "," or ";" (whatever the other delimiting characters), then replace ")" with "" (nothing). Don't actually input the quotes. You will now have a display name without the email, which is moved to it's own column, but I think you wouldn't mind.
Vijaya Babu SekarAssociate Ops ManagerCommented:
you may try to below cmdlets

Get-Mailcontact -ResultSize Unlimited |Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}} | Export-CSV c:\smtp.csv -NoTypeInformation

Open in new window


Get-Mailcontact | select FirstName,LastName,Displayname,WindowsEmailAddress| export-csv c:\Mailcontacts.csv -Encoding UTF8

Open in new window

Alex_LAuthor Commented:
Thanks I partially used this solution as no one else seemed willing to step up to the plate.
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.

All Courses

From novice to tech pro — start learning today.