Email to an MS SQL Table

[Curious Joe]

I have some emails (~1,500,000) that I need to throw into a SQL System
for some extensive analysis.

I know how to script a macro to traverse through all of the emails in
the system but I am wondering if there is a way to access ADO/ODBC of
any type from VBA in Outlook.

Any help is appreciated.

Thanks,

CJ

 

[Ken Slovak - [MVP - Outlook]]

Just set a reference to the ADO of your choice in the Outlook VBA project
and use it all you want. I've used ODBC and ADO many times from Outlook VBA.
What you can't do is use an ADO or ODBC connection to Outlook and expect to
get anywhere near the actual number of properties that exist on an item, and
some properties (email addresses for one) are security restricted for ODBC
connections and not for native VBA Outlook object model code.