baleman2
asked on
Export Names and Addresses from Distribution Group in Exchange 2007
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-DistributionGroupMembe r -Identity "EnterDLNameHere" | Get-Mailbox | ft DisplayName,PrimarySMTPAdd ress
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-DistributionGroupMembe r -Identity "EnterDLNameHere" | Get-Mailbox | ft DisplayName,PrimarySMTPAdd ress | 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
The following command (from Powershell) displays the data that I need:
Get-DistributionGroupMembe
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-DistributionGroupMembe
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.