Export all mailboxes' contacts to CSV

powershell csv exchange-server pst
JulioQc picture JulioQc · Sep 8, 2016 · Viewed 7.4k times · Source

Is there a way to export all the contacts for each mailboxes in Exchange 2010 to a format easy to import to MS SQL? (i.e. CSV)

So far I got this working but a PST format is absolutely pointless:

foreach ($i in (Get-Mailbox)) { New-MailboxExportRequest -Mailbox $i -FilePath “\\computer\c$\pst\$($i.Alias).pst” -IncludeFolders “#Contacts#” -ExcludeDumpster}

The objective is to automate the task so we can run it each week or so.

Answer

Glen Scales picture Glen Scales · Sep 9, 2016

You can use EWS (Exchange web services) to access and then export Mailbox content there are a bunch of examples for exporting contacts eg

https://github.com/wadimk/PowerShell-Scripting/blob/master/PowerShell%20Script%20Project/EWS-Export-Contacts.ps1

https://gallery.technet.microsoft.com/office/Export-Contacts-from-OWA-9f8cc0f2

http://gsexdev.blogspot.com.au/2014/02/exporting-contacts-to-csv-file-using.html

Related questions

PowerShell: how to count number of rows in csv file?

How can I count the number of rows in a csv file using powershell? I tried something like Get-Content -length "C:\Directory\file.csv" or (Get-Content).length "C:\Directory\file.csv" but these result an error.

Read More
run powershell command using csv as input

I have a csv that looks like Name, email, address Name, email, address Name, email, address I am wanting to run New-Mailbox -Name "*Name*" -WindowsLiveID *email* -ImportLiveId (where *x* is replaced by the value from the csv). on each line …

Read More
Powershell Export to CSV from ForEach Loop

I'm new to Powershell but I've given it my best go. I'm trying to create a script to copy a file to the All Users Desktop of all the XP machines in an Array. The script basically says "If the …

Read More