Export Exchange 2007 Distribution Group and All Associate SMTP Addresses to CSV

power shell command should pull all the information for each member in the group

Get-DistributionGroupMember "<Group Name>" | Export-CSV -Path "<FileName>"

if you want all groups with certain fields like display name and smtp only you can use this in powershell

Get-DistributionGroup | %{
  $Group = $_
  $Group | Get-DistributionGroupMember |
    Select-Object @{n='GroupName';e={ $Group.Name }}, DisplayName, PrimarySMTPaddress
} | Export-CSV "filename location"

here you go

$gprs = Get-DistributionGroup -ResultSize unlimited

$grps | %{$n = $_.name; Get-DistributionGroupMember $_} | Select-Object name,@{label="Group";expression={$n}} | export-csv c:\list.csv

Select allOpen in new window

To view the specific field names that you might want for exchange users
get-mailbox -identity "<domain\username>"  | fl

John & Akhater,
I tried your suggestions, howeve the resultant set only gives me Distro list and Members email addresses.  I need to get the Distro lists, as well as the Distro lists associated email addresses.  So for example, I have a Support Distro list that when someone emails either support@xyz.com or supportIT@xyz.com or help@xyz.com, when I run this powershell script it should give me;
Support, Support@xyz.com, SupportIT@xyz.com, help@xyz.com.  I found the following, however I want it to export it rather than write it to the screen, however my lack of understanding of coding leaves me drawing a blank.

Get-DistributionGroup | select name , alias ,EmailAddresses | foreach {
   “Name: “+$_.name
   “Alias: “+$_.alias
    $_.EmailAddresses | foreach {
      if($_.SmtpAddress){
      “SmtpAddress: “+$_.SmtpAddress
    }
 }
 write-host
 }

Select allOpen in new window

You lost me, you wanted to groups members now you are looking for the aliases of the groups?

Get-DistributionGroup -resultSize unlimited | select name -expand emailAddresses | where {$_.smtpAddress} | Export-Csv c:\t.txt

I don't believe I ever said I needed the group members, but it is an added benefit I received from this post.  I have saved all of these scripts as I can definitely see the benefit of what you all have posted so far.  But yes, the aliases of the group.  
The script you gave me doesn't return all the aliases for each group, just the first.  

Thanks again, I do appreciate your help.

sorry i dont know why i thoght u asked for the members :)

Use your script just add at the end > c:\t.txt

and sorry my script doesn't export only the first alias it exports them , check the csv you will see multiple entries for the same group each one for an smtp address

Getting closer.  I put that right after the "Write Host" and I get a blank document.  If I take out the "Write Host", I get

The term '>' is not recognized as the name of a cmdlet, function, script file,
or operable program. Check the spelling of the name, or if a path was included,
 verify that the path is correct and try again.
At C:\BC_Scripts\DistributionList.ps1:9 char:3
+  > <<<< c:\at.csv
    + CategoryInfo          : ObjectNotFound: (>:String) [], CommandNotFoundEx
   ception
    + FullyQualifiedErrorId : CommandNotFoundException

Just saw your post.  Let me check.

sorry, I thought I ran yours earlier, however I just ran your script and received the following;

Get-DistributionGroupMember : Cannot bind argument to parameter 'Identity' beca
use it is null.
At line:1 char:52
+ $grps | %{$n = $_.name; Get-DistributionGroupMember <<<<  $_} | Select-Object
 name,@{label="Group";expression={$n}} | export-csv c:\list3.csv
    + CategoryInfo          : InvalidData: (:) [Get-DistributionGroupMember],
   ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationErrorNullNotAllowed,M
   icrosoft.Exchange.Management.RecipientTasks.GetDistributionGroupMember

That worked perfectly.  Thank you very much for your help, and with your patience.  I sincerly appreicate it.

You are welcome and thanks for the points