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?

1 Answer 1


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.

  • Hi @Julian Knight would you know of a link or tutorial which can do the same? Commented Jan 12, 2021 at 12:59
  • 1
    @manishKungwani, I searched for "powerquery example exchange online" and it came back with this as the 1st entry (lots of others to choose from as well): powerbi.microsoft.com/en-us/blog/… Commented Jan 12, 2021 at 15:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.