How can I extract a complete list of email addresses I've ever interacted with in Outlook — including those not saved in my contacts?

Question

How can I extract a complete list of email addresses I've ever interacted with in Outlook — including those not saved in my contacts?

Chirag Sutar 20

I want a list of all email ids which I have ever engaged with from my inbox. These are not the emails I have added to 'contacts' which of course would have made it easier to export. The solution I am looking for is an option where I can find a list of all email ids with whom I have ever exhanged emails. Right now, the only option is going back as far as possible and copy-pasting those email ids manually. This is very time consuming.

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Hi @Chirag Sutar

Thank you for posting your question in the Q&A Forum.

Regarding your question about retrieving a list of email addresses you have previously interacted with in Outlook. While Outlook doesn't offer a built-in feature to automatically generate such a list, you can achieve this using the Export function. Here's a step-by-step guide:

Open Outlook and go to File > Open & Export > Import/Export.
In the Import and Export Wizard, select Export to a file and click Next.
Select Comma Separated Values, then click Next.

User's image

Choose the folder you want to export from (e.g., Inbox or Sent Items), then click Next.
Click Browse to choose the location to save the exported file.

User's image

In the Browse dialog box:

Choose a folder where you will save the file.
Enter a file name in the File name box.
Click OK.

User's image

In the Export to a File dialog box, click Map Custom Fields.
Click Clear Map to remove default fields.
Drag the following fields from the left box to the right:
- From: (Address)
- To: (Address)
- CC: (Address)
- BCC: (Address)
- Click OK.

User's image

Outlook will then export the email addresses from the selected folder into a CSV file. Depending on the number of emails, this may take a few minutes. Once complete, you can open the file in Excel to filter and extract unique addresses.

There might be some minor manual cleanup involved to filter out duplicates or less relevant entries, but overall, this method should give you a solid foundation to work from.

If you're working with a large volume of emails or need a more automated approach, options like VBA scripting, PowerShell, or trusted third-party tools are available. I'd be happy to walk you through those if you're interested.

Let me know if you’d like help with any of these steps, we’re here to support you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.