Extract all current emails in inbox to Excel

Like (0) Share

Report

Posted on 4 Jan 2023 19:43:32 by PhillipDK

Hi all!

What is the best way to extract all mails in current mailbox to Excel.

The stuff I want to extract from mail to Excel is:

Subject, To, From, and Conversation ID.

It is very important I get the conversation ID.

I have tried to use Power Query Editor, which works like a charm! But it doesn't give me the conversation ID, only the message ID (Which is useless to me).

It does not have to automated or anything. It is only for one time use. I really hope somebody in here knows how to figure it all out.

Thank you in advance 🙂

All responses (1)

Answers (0)

David_MA 10,973 Super User 2025 Season 1 on 04 Jan 2023 at 20:31:42

Like (1)

Report

Re: Extract all current emails in inbox to Excel

I have only just started exploring what you can do with HTTP requests to the Graph API, but that looks like an approach you can take. Looking at Graph Explorer | Try Microsoft Graph APIs - Microsoft Graph and running the Get my mail request, it returns the data you need. This is a YouTube video I watched to start learning about what this can do: https://youtu.be/yGYmgY3OgXk