Powershell – How to export / import all email aliases for an Exchange 2010 User Account

emailexchange-2010exportimportpowershell

I have a number of users in our 2010 Exchange server. I wish to export (into a file) all the email addresses for a particular user. Later on, I wish to be able to import all the email addresses once more into the user (lets assume all the emails to be imported do NOT exist in any user account).

Anyone have any ideas how to do this?

Powershell magic, anyone?

Best Answer

I figured out the answer.

In exchange powershell ...

> $mbx = Get-Mailbox someUserName
> $mbx.EmailAddresses | where { $_.IsPrimaryAddress -eq "False" } | Export-CSV "C:\SomePath\wherever.csv"
> $mbx.EmailAddresses | where { $_.IsPrimaryAddress -eq "False" } | foreach { $mbx.EmailAddress -= $_.SmtpAddress }
> Set-Mailbox someUserName -EmailAddresses $mbx.EmailAddresses

> $mbx = Get-Mailbox theNewUser
> Import-CSV "C:\SomePath\wherever.csv" | foreach { $mbx.EmailAddresses += $._SmtpAddress }
> Set-Mailbox theNewUser -EmailAddresses $mbx.EmailAddresses

that's it :)

Of course, you might need to modify the contents of the csv file after the export and before the import.

I also had to delete all the existing email's from the someUserName so there were no duplicates in theNewUser

good luck :)

Related Solutions

How to set up email alias in exchange 2010

Being able to reply from one of your aliases in Exchange is a question that gets asked a lot, and unfortunately there is no easy solution, despite people asking for it since Exchange 2000. As far as MS is concerned email addresses you have setup as aliases are just a way to route email to you, and that's it. Take a look at this question that talks about being able to send from alternative addresses.

In your situation, what I would suggest is to set up separate mail accounts for these addresses you want to send and receive from, and give the user who needs to access them full permissions, including send as rights. They can then add these mailboxes as additional mailboxes in Outlook, so they can operate them through a single Outlook instance, but they remain as separate entity's.

Powershell – Automatically sending a ‘Welcome’ email to all new user accounts

I’m utilizing this script with Exchange 2010 but I had to make a few small tweeks. Also be sure your running this from one of the cass servers First off change the PSSnapin to load the Exchange 2010 module.

“   if (-not((Get-PSSnapin) -match "Microsoft.Exchange.Management.PowerShell.E2010")){ Add-PSSnapin Microsoft.Exchange.Management.PowerShell.E2010 }   ”
Next, edit the $SMTPClient to match this line- “   $SMTPClient = New-Object Net.Mail.SmtpClient("127.0.0.1")  “

After you have the script customized run this section of the command to create a reg key.

##########################BEGIN####################
$strScriptName = $MyInvocation.MyCommand.Name
if (!(Get-ItemProperty HKLM:\Software\Innervation\$strScriptName -Name LastRun -EA SilentlyContinue)){
    # this is the first time the script has run - let's create the registry key and value for future runs
    New-Item -path HKLM:\Software\Innervation -EA SilentlyContinue | Out-Null
    New-Item -path HKLM:\Software\Innervation\$strScriptName | Out-Null
    New-ItemProperty -path HKLM:\Software\Innervation\$strScriptName -Name "LastRun" -Value (Get-Date) -propertyType String | Out-Null
    write-host "Initial configuration completed." -ForegroundColor green
}
# get time stamp from registry so we know when it last ran
$LastRun = Get-Date ((Get-ItemProperty -path HKLM:\Software\Innervation\$strScriptName -Name LastRun).LastRun)
$ElapsedTime = ((Get-Date) - $lastrun).TotalSeconds
######################END####################################

Then comment out the last line for testing purposes.

#########################BEGIN###############################
Set-ItemProperty HKLM:\Software\Innervation\$strScriptName -Name "LastRun" -Value (Get-Date) | Out-Null
######################END#######################

Create a new user account and test your script till your happy. After it works as intended remove the comment.

@Toshana

Best Answer

Related Solutions

How to set up email alias in exchange 2010

Powershell – Automatically sending a ‘Welcome’ email to all new user accounts

Related Topic