# Complete export with statistics
$mailboxes = Get-Mailbox -ResultSize Unlimited
$results = foreach($mailbox in $mailboxes) {
    $stats = Get-MailboxStatistics -Identity $mailbox.UserPrincipalName
    [PSCustomObject]@{
        DisplayName = $mailbox.DisplayName
        UserPrincipalName = $mailbox.UserPrincipalName
        MailboxType = $mailbox.RecipientTypeDetails
        TotalSize = $stats.TotalItemSize
        ItemCount = $stats.ItemCount
        LastLogon = $stats.LastLogonTime
        ProhibitSendQuota = $mailbox.ProhibitSendQuota
    }
}
$results | Export-Csv -Path "C:\temp\ExchangeMailboxes.csv" -NoTypeInformation -Encoding UTF8

# Detailed DL groups export
$groups = Get-DistributionGroup -ResultSize Unlimited
$results = foreach($group in $groups) {
    $members = Get-DistributionGroupMember -Identity $group.Identity
    foreach($member in $members) {
        [PSCustomObject]@{
            GroupName = $group.DisplayName
            GroupEmail = $group.PrimarySmtpAddress
            MemberName = $member.DisplayName
            MemberEmail = $member.PrimarySmtpAddress
            MemberType = $member.RecipientTypeDetails
        }
    }
}
$results | Export-Csv -Path "C:\temp\DistributionGroups.csv" -NoTypeInformation -Encoding UTF8

# CSV format: DisplayName,UserPrincipalName,FirstName,LastName,Department
$users = Import-Csv -Path "C:\temp\NewMailboxes.csv" -Delimiter ";"
 
foreach($user in $users) {
    try {
        New-Mailbox -Name $user.DisplayName `
                   -UserPrincipalName $user.UserPrincipalName `
                   -FirstName $user.FirstName `
                   -LastName $user.LastName `
                   -Department $user.Department
        Write-Host "Mailbox created: $($user.DisplayName)" -ForegroundColor Green
    } catch {
        Write-Host "Error creating $($user.DisplayName): $($_.Exception.Message)" -ForegroundColor Red
    }
}

# CSV format: GroupName,MemberEmail
$members = Import-Csv -Path "C:\temp\GroupMembers.csv" -Delimiter ";"
 
foreach($member in $members) {
    try {
        Add-DistributionGroupMember -Identity $member.GroupName -Member $member.MemberEmail
        Write-Host "Added $($member.MemberEmail) to $($member.GroupName)" -ForegroundColor Green
    } catch {
        Write-Host "Error adding $($member.MemberEmail): $($_.Exception.Message)" -ForegroundColor Red
    }
}