Solved

Export Names and Addresses from Distribution Group in Exchange 2007

Posted on 2013-01-22
1
549 Views
Last Modified: 2013-01-22
I need a list of a Distribution Group's members.  The list needs to be comprised of "Name" and "Email Address" and in a format that allows it to be opened in an Excel spreadsheet.

The following command (from Powershell) displays the data that I need:

Get-DistributionGroupMember -Identity "EnterDLNameHere" | Get-Mailbox | ft DisplayName,PrimarySMTPAddress

The output from the command looks like this in the PowerShell window:
 
Display Name                                       Primary Address
----------------------------------------------------------------------------------------------------------------
Jack Smith                                             jsmith@whatever.com
Jand Doe                                               jdoe@whatever.com

The following command exports it to a file named "data.csv":

Get-DistributionGroupMember -Identity "EnterDLNameHere" | Get-Mailbox | ft DisplayName,PrimarySMTPAddress | Export-CSV c:\data.csv

However, when I open the file in an Excel spreadsheet, I get line items of information enclosed in brackets.

I've attached a screenshot.

Is this a syntax error or what?
LL-list.csv
0
Comment
Question by:baleman2
1 Comment
 
LVL 10

Accepted Solution

by:
ddiazp earned 500 total points
ID: 38808372
I assume highlighting the results, and copy/paste into Excel is not an option? (list too large?)

What about this?

Get-DistributionGroupMember -Identity "EnterDLNameHere" | Get-Mailbox | ft DisplayName,PrimarySMTPAddress >  c:\data.csv

Then you can either copy/paste special on excel, or open it on excel
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

803 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