How to export GAL/internal contacts to .CSV with their SMTP address?

Question

How to export GAL/internal contacts to .CSV with their SMTP address?

Joe Grover 566

When exporting Contacts to .CSV, internal users are not exported with their SMTP address, instead having the X500-ish address like /o=ExchangeLabs/ou=Exchange Administrative Group etc. I've tried both using the Outlook 365 desktop client as well as OWA; both .CSV files have the same info.

Is there a way to export the contacts in a way that includes the SMTP address? We have a user that will be continuing to work with us on a contract basis, but will no longer have a mailbox in our organization.

1 answer

Your answer

Answer 1

Kael Yao 37,746 Moderator

Hi @Joe Grover

When exporting Contacts to .CSV, internal users are not exported with their SMTP address, instead having the X500-ish address like /o=ExchangeLabs/ou=Exchange Administrative Group etc.

Did you mean you would like to export all the user mailboxes and shared mailboxes in the tenant to a PST file?
If you have the required permissions, I suppose that you may use EXO powershell to do it.
The command would be like:

Get-Mailbox -ResultSize unlimited -RecipientTypeDetails UserMailbox,SharedMailbox,RoomMailbox | Select-Object DisplayName, PrimarySMTPAddress | Export-Csv C:\temp\contoso.csv

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Joe Grover 566 Reputation points

2021-09-01T13:40:52.043+00:00

No, I'm trying to export one user's contacts which contains internal users they added from the GAL. Normal contacts export normally, but the internal users don't include the SMTP address, which won't do him any good once he's no longer on our system.

I could try to curate the output from the command you provided, however that method seems to only give me their name and SMTP address, and doesn't include their contact info (phone numbers, addresses, etc) that are in the user's contact. This could be manually updated, but there are almost 800 of them (many of which he doesn't need).
Kael Yao 37,746 Reputation points Moderator

2021-09-06T08:48:11.24+00:00
Hi @Joe Grover

Sorry I misunderstood your question.
Thanks for the clarification.

If you would like to also extract the other contact information which is stored in Azure AD, please use this command instead:

Get-User -ResultSize unlimited -RecipientType UserMailbox,SharedMailbox,RoomMailbox | select-object Name,office,*phone*,*address* | Export-Csv C:\temp\contoso.csv

You can add the parameter of the information(phone numbers, addresses) which you would like to extract in the select-object part.
To have a view of all the available contact information, you may use the following command:

Get-User -identity <user for test> | fl
Kael Yao 37,746 Reputation points Moderator

2021-09-09T09:27:02.063+00:00

Hi @Joe Grover

I am writing here to confirm with you how thing going now?
Do suggestions above help?

If you have any questions or needed further help on this issue, please feel free to post back.
If the issue has been resolved, please mark the helpful replies as answers, this will make answer searching in the forum easier and be beneficial to other community members as well.
Joe Grover 566 Reputation points

2021-10-07T13:19:45.223+00:00

It was a pretty cumbersome process. The user didn't want the entire directory, they only wanted the ones they'd copied to their contacts (which was about 60 out of over 1000 corporate contacts). I wound up just searching their contacts for the corporate users they'd added, made a note of them, then deleted them and manually added them all for them. :(

I wish there'd just been a way to export the contacts from their contact list with the SMTP addresses themselves instead of the Exchange addresses.
Kael Yao 37,746 Reputation points Moderator

2021-10-12T06:19:40.583+00:00

Thanks for the update.
Glad to hear you found a solution in the end and sorry for the inconvenience caused.

Share via

How to export GAL/internal contacts to .CSV with their SMTP address?

1 answer

Your answer