Solved

EXPORT MAIL ADDRESSES EXCHANGE 2010

Posted on 2015-02-13
2
167 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
Pop culture is prime bait for hackers seeking to infect user’s computers and mobile devices with malicious malware. Hackers know exactly what the latest trends are online and know how to use them to their advantage.
The purpose of this video is to demonstrate how to use PicMonkey software to customize images for a Mailchimp campaign. Picmonkey is free and simple online software which can be used by users who don’t have robust editing software such as Photoshop,…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

756 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