One-liner to export all email addresses to CSV

This command exports all email addresses for all users in the organization:

Get-Mailbox -ResultSize Unlimited | Select-Object DisplayName, SamAccountName, PrimarySmtpAddress, @{Name="EmailAddresses";Expression={$_.EmailAddresses | Where-Object {$_.PrefixString -ceq "smtp"} | ForEach-Object {$_.SmtpAddress}}} | Export-CSV c:\EmailAddresses.csv -NoTypeInformation -Encoding Unicode

If you want to narrow it down a bit you could add either a Where or narrow the scope sown to a specific OU as in the following example:

Get-Mailbox -ResultSize Unlimited -OrganizationalUnit "sundis.local/Test/Users" | Select-Object DisplayName, SamAccountName, PrimarySmtpAddress, @{Name="EmailAddresses";Expression={$_.EmailAddresses | Where-Object {$_.PrefixString -ceq "smtp"} | ForEach-Object {$_.SmtpAddress}}} | Export-CSV c:\EmailAddresses.csv -NoTypeInformation -Encoding Unicode

Let me know if you have any questions!

Advertisements

5 Responses to One-liner to export all email addresses to CSV

  1. Paul says:

    Unexpected token ‘Expression=’ in expression or statement.
    At line:1 char:134
    I get this error when copy/paste/execute this script line
    Paul

  2. Thanks Martin, the command worked for me.

    A similar method, shorter, but the output isn’t as pretty is:

    Get-Mailbox | Select-Object Displayname, SamAccountName, PrimarySMTPAddress, EmailAddresses | ft Displayname, SamAccountName, PrimarySMTPAddress, emailaddresses -wrap > c:\emails.csv

    Carl

  3. He comprado un vehículo a una empresa de compraventa.

  4. Marathonit says:

    This was helpful, especially the way you extracted all the aliases as well. I had to manipulate the output a bit, as the aliases were all in one column, surrounded by quotes. However, this saved me a bunch of work, and inspired me to learn a bit more about Powershell output manipulation.
    Thanks for sharing…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: