How to get email address of the mailboxes.

Question

I have the display name of the users in a csv file. I want to know their email address from PowerShell. I am not able to run the command in AD to get this information. Please provide a PowerShell command which I can run in Exchange online to achieve this.

Answer 1

Hi，

Thanks for posting your question in the Microsoft Q&A forum.

Based on your description, I would suggest that you use the Import-Csv " location of the CSV file \name.csv" | ForEach-Object {  Get-Mailbox -Identity $_.DisplayName | Select-Object DisplayName,PrimarySmtpAddress} cmdlet to get the user's email address.

Make sure your CSV file has a column named "DisplayName" and a column named "PrimarySmtpAddress".

Here are my test over results:

If my reply helps you, please mark him as an answer. Thanks for the support and understanding.

Answer 2

See

https://learn.microsoft.com/en-us/powershell/module/exchange/get-user?view=exchange-ps

https://learn.microsoft.com/en-us/powershell/module/exchange/get-mailuser?view=exchange-ps