Extracting Data From Outlook 2007
James Fisk, Bell Labs
Outlook fields exported to an Excel file
I started this process by trying to extract email from Outlook to an Excel file for summarizing information. Although the export works well for obtaining some of the email information, including Categories, subject, to/from, and the Body - it is missing a critical piece: the date!
Outlook fields (export)
Outlook fields pulled into an Access database file
Starting from the other side of this problem - using Access 2007 to get External Data from an Outlook file, works well , retrieving the 3 different date/time stamps for each message (Received, Created, Modified) ... but no Categories! Starting from Access is better as there is more extensive info, including email size, attachment flag, and some other details.
The resulting table in Access (pulled in from Outlook using External Data menu) has these fields (annotated with my keep criteria and notes):
Linking the 2 files in Access
Using both files, the Export from Outlook and the Access file pulled from Outlook, is a decent hack for adding the Categories field to Access. But it requires a little faith that the export/import order is exactly the same in the 2 methods (it appears to be!). Before establishing a relationship in Access between the two tables, the export from Outlook requires an autonumber primary key field. Of course check that the resulting relationships make sense. My simple file testing showed it was ok. Export / import order was oldest to newest.
Using VBA for a customized extract
If more than a hack is required! The alternative is to write VBA to create the exact set of data that you need. Some info to get started, with sample code:
Back to Outlook
|Page last modified on October 10, 2012, at 05:32 PM - Powered by PmWiki|