Avatar of TechGuise
Flag for United States of America asked on

Find messages in a PST file based on values in a list in ACCESS or EXCEL

I have multiple PST files (not currently being used in any OUTLOOK installation).   I would like to create a list in EXCEL or ACCESS, and search for matches for anything on that list within those PST files.   Does anything like this exist.... or could something be built using VBA in EXCEL or ACCESS?

OutlookMicrosoft AccessVBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon
John Tsioumpris

Well this is an interesting question...
The fact is that usually .pst files are huge...beyond the 2 GB limit of Access and i guess similar to Excel (i don't recall seeing Excels bigger than 100-200Mb but you never know)
The usual way is to import these .psts to Outlook and use Outlook Automation  via Access (or Excel) VBA to navigate to the .PST file structure and extract the needed information.

So if I import these PST's into OUTLOOK.....    
does anyone know of ACCESS or EXCEL code that will search for messages based on values in a list?
John Tsioumpris

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

Never figured anything out, guess I should close question?
John Tsioumpris

What is exactly your status..

Have you imported the .PST

Have you read the article...copy/paste some code and started "poking" around to get the Correct Objects/Collection (aka Folders)


Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question