We help IT Professionals succeed at work.

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

TechGuise
TechGuise asked
on
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?

Thanks
Comment
Watch Question

View Solution Only

John TsioumprisSoftware & Systems Engineer
Distinguished Expert 2019

Commented:
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.
TechGuise

Author

Commented:
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 TsioumprisSoftware & Systems Engineer
Distinguished Expert 2019

Commented:
TechGuise

Author

Commented:
Never figured anything out, guess I should close question?
John TsioumprisSoftware & Systems Engineer
Distinguished Expert 2019

Commented:

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)

Commented:
I eventually paid a developer to write a program that performed the tasks needed.