I need to periodically receive pst files, extract the contents from them and store them in a database.
Outlook automation is not the best option because it prompts you to allow anonymous access before letting you process and email. I would like no use interaction if possible.
The automation is the best way at present, what is the email source is this exchange ? If so you could look at using CDO and or if you need to extract, you can use MSACCESS and import the data from clicking Import Tables and selecting Outlook() and then confirming the folders you wish to use, I think this maybe a quick way to solve the issues.
There are tools that use MAPIX to automate with MAPI and get access to the data which dont prompt for Anonymous access. www.outlookspy.com is a good reference to start with this.
Regards
