How to extract email addresses from emails on Office 365

contactsexportoffice-365outlook.com

I need to create a list of email addresses of those I've been emailing and who have been emailing me via my office 365 email account.

If it were a hundred or so people then I'd just do it by hand (make a contact for each one, then export the contact list), but I have thousands of people I've been in contact with that I need to record. I do have access to the admin panel on office 365 if needed.

What is the easiest method for me to extract a list of email addresses from my email itself, including email recipients for emails I've sent, and email senders for emails I've received?

Best Answer

If you have a reasonably up-to-date version of Office, the easiest method is to use Excel with PowerQuery.

PowerQuery has a source for Office 365 and Exchange Online. Connect up to the Mail entry and you can access all the From, To, CC and BCC entries. Takes a bit of wrangling but it is all point and click. No programming.

Related Solutions

Gmail – Get email addresses from Gmail message body

You would need to write some sort of regex to extract that string from the message.

var threads = GmailApp.getInboxThreads();

for (var t in threads) {

  var messages = threads[t].getMessages[];
  var text = messages[0].getPlainBody();

  var matches = /From:(.*?)<(.*?)>/gi.exec(text);
  if (matches) 
      Logger.log(matches[1] + " :: " + matches[2]);

}

Office 365 – Using Excel Survey in Office 365 for Business

We had the same concern. So we created a new site collection specifically for surveys. Then we turned on the setting "Allow both external users who accept sharing invitations and anonymous guest links: in our Tenant, and turned it off for all site collections except the one we will use only for Excel Surveys.

Best Answer

Related Solutions

Gmail – Get email addresses from Gmail message body

Office 365 – Using Excel Survey in Office 365 for Business

Related Topic