Get list of all people I've e-mailed in Office 365

0

When you e-mail someone in Office 365 (through webmail or Outlook client), it must "store" the recipient's address somewhere as when you then go to e-mail them later on their name can autocomplete in the address bar (e.g. if I've e-mailed sales@blah.com, I can then start typing a new e-mail and write "sa" into the address bar and it will suggest sales@blah.com).

Is there a way of getting a list of these e-mail addresses?

I'm basically trying to find a list of any e-mail addresses I have sent to in the past (preferably date-filtered, if this is possible). We're moving e-mail domains on fairly short notice so I'd like to show staff how to e-mail everyone they need to saying "please update your records, I'm now using X.Y@domain.com e-mail address".

EDIT: I am trying to get a list of my O365 users' e-mail recipients, e.g. people they have sent e-mails to, rather than a list of my O365 users' e-mail addresses.

Ideally I would like the users themselves to be able to do this - to get a list of e-mail addresses which they can then send a BCC'd e-mail to stating "I have changed e-mail address".

dunc

Posted 2016-07-14T15:31:57.863

Reputation: 155

Can you export all emails to csv? Then use excel to filter? – Dave – 2016-07-14T16:09:56.577

Also, do you have both domains? If so then use OOO – Dave – 2016-07-14T16:19:30.170

This question has already been answered here http://superuser.com/questions/50006/how-can-i-export-all-email-addresses-i-have-sent-to-from-outlook-or-any-other-em

– Shafiq – 2017-01-10T13:29:18.973

Answers

0

EDIT
Here are steps for connecting to Office 365 in Powershell

$session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri "https://outlook.office365.com/powershell-liveid/" -Credential $cred -Authentication Basic -AllowRedirection

Enter username and password

Import-PSSession $session

Powershell gives you a great and easy tool to achieve such in a very few short steps
1) Connect to office 365 in Powershell
2) Run the below cmdlet

et-Recipient -ResultSize Unlimited | select DisplayName,RecipientType,EmailAddresses | Export-Csv email-recipients.csv

This puts the results in a CSV file for you. Here is the full link if needed

https://www.cogmotive.com/blog/office-365-tips/export-all-email-addresses-from-office-356

user2676140

Posted 2016-07-14T15:31:57.863

Reputation: 1 629

Doesn't this just return all of the e-mail addresses in my O365 tenancy? I'm looking to do this for my O365 users to see who they have sent e-mails to - primarily outside the organisation. – dunc – 2016-07-14T15:37:35.643

Yes, it would return for the user credentials that were supplied. Sorry, I read your post as you were wanting to provide your users a method on how to export email addresses. – user2676140 – 2016-07-14T15:38:35.740

Could be my mistake, I don't think I wrote the post well. I've included an edit to clarify. – dunc – 2016-07-14T15:39:15.917

So YOU want to query your mail server and get a list of ALL email addresses that have been mailed by any email account not just your own? – user2676140 – 2016-07-14T15:41:10.033

Only if I can separate it out by user, e.g. "me@mydomain.com has e-mailed blah@blah.com, blah@blah1.com" and "you@mydomain.com has e-mailed blah2@blah.com, blah@blah2.com" etc. – dunc – 2016-07-14T15:42:41.527

Is your mail server hosted locally or in the cloud? If hosted locally, do you have an admin panel you can access that could provide you this ability? – user2676140 – 2016-07-14T15:45:04.413

It's a cloud-hosted O365 domain with Azure AD sync. – dunc – 2016-07-14T15:46:04.013

The cloud is a blessing and a curse... Since it is cloud based you really have limited control over the "server" itself. How many users? – user2676140 – 2016-07-14T15:48:51.107

If it's a Microsoft managed service you could try asking customer support to do it for you. <-- O(1) solution right there. – Parthian Shot – 2016-07-14T16:55:22.613