Solved

EXPORT MAIL ADDRESSES EXCHANGE 2010

Posted on 2015-02-13
2
179 Views
Last Modified: 2015-02-13
Hello - I need to export all of mail addressed inclusive of alias addresses into a single column CSV file for import into a cloud based Spam filter.

I found this on line

Get-Mailbox -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

It is helpful but I need the alias addresses to appear in the 1st column as separate addresses.  Can anyone help I have no idea how to achieve this

Byron
0
Comment
Question by:BYRONJACKSON
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
Guy Lidbetter earned 500 total points
ID: 40607882
Hi Byron..

Give this a go...

$MailAccounts =  Get-Mailbox -Resultsize Unlimited | Select -ExpandProperty EmailAddresses
$MailAccounts.SMTPAddress | Export-CSV <FileName>

Regards

Guy

EDIT: It only provides a list of all mailbox users email addresses (Primary and Proxy) - nothing else. You would need to do the same for Distribution groups and mail enabled Public folders.
0
 

Author Closing Comment

by:BYRONJACKSON
ID: 40608273
Thank you! Perfect
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
It’s a strangely common occurrence that when you send someone their login details for a system, they can’t get in. This article will help you understand why it happens, and what you can do about it.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question