Wednesday, 27 January 2016

Export all your Exchange Email Addresses to CSV

This below command works with Exchange 2007 and 2010.

Open up exchange powershell and type this:

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

This will extract the users into a nice excel sheet in the C Drive for you to use.


To export the usernames and inbox sizes use the command below:

Get-mailbox | get-mailboxstatistics | sort-object totalitemsize –descending | ft displayname,totalitemsize | Export-CSV c:\emails.csv -NoTypeInformation

1 comment:

  1. EdbMails EDB to PST Converter Tool is an effective & reliable tool provides impeccable recovery. This tool recover & repair all damaged .edb files and then transfer them into usable format that is PST. It supports all versions of Windows and restore PST files in your location. It restores all files in original formats such as HTML, Text, RTF, etc. It is preview of all damaged or corrupted EDB files before restoration. Free availability of trial version with the help of you can easily understand the complete procedure of recovery.

    For more information visit: Convert EDB to PST