How to export Outlook email messages to excel spreadsheet

[touque]

I have a massive Outlook email folder I want to export to an excel spreadsheet. The emails are short and I want to use data to sort and filter.
I found how to export as a .pst file saved to my hard drive.
Is there a way I can open the .pst file?

 

[JEC]

You can also import with power query. Use microsoft exchange connector

 

[DanteAmor]

Hi @touque.

In the following threads you will find answers to directly read the emails and put the information in excel, check if you can adapt any to your needs:

VBA code for outlook to find serial number from excel

Hi, I am really not good to work with outlook codes, so here I am. I have a list of serial numbers in a random column, let's say column B. I need to copy the code, and need to find in email body or subject in outlook, returning the e-mail who sent me and what time was it. I think that's not...

www.mrexcel.com

VBA Help - Excel and Outlook

I have a macro in Excel to go into a specific Outlook folder. For all emails in that folder I want to copy the sender email address, subject, body, and date into Excel. When I run the code it returns a an error 'Run-time error 438: Object doesnt support this property or method'. Can someone...

www.mrexcel.com

Copy texts from current email in Outlook to cells in Excel

Hello everybody! I want to create a macro that copies texts from the current email in Outlook and pastes it into cells in the row of a spreadsheet, as a manual procedure is laborious and repetitive. Something that is seemingly simple, and it should be. I wrote the code below, but I can't...

www.mrexcel.com

Extracting SubFolders from Outlook using Excel VBA

I would like to extract out subject from shared outlook email. I manage to extract out inbox but subfolder are not extracted out. Anything wrong with my code below? Shared email > Inbox > subfolder1 (under subfolder 1 has few folders) Public xlSht As Excel.Worksheet Sub...

www.mrexcel.com

 

[touque]

Thanks folks, I will try the above suggestions. I just got pulled away so I cannot attempt right now.