Outlook 2003 and Access 2003

[Tony Cannizzo]

My goal is to add a record to an Access table for each individual email in
Outlook.

Exporting emails from an Outlook folder to an external file is perfect,
except for the date field which is missing from the export.

Is there a way to get the date into the export? or is there a better
approach to getting this information from Outlook to Access?

Thanks
tc

 

[Tony Cannizzo]

Thought I would post this for anyone's future reference

In Access, File>Get External Data>Import>File Type=Outlook()
This brings up the Exchange/Outlook Import Wizard
It browses your entire Outlook Folder structure
Pick a folder and it gets Imported into an Access table

You get everything as separate fields in each record for each email
Recieved (date/time)
From
To
Cc/Bcc
Subject
Body (memo field)
Message size
Whether it had attachments or not
and about 20 other cool fields.

 

[amitbhandari]

Yes, basically, the OOM does expose GetTables() method where in you get
MAPITable which is similar to the traditional table having rows and columns
and the columns being the various fields associated with that particular
type of item and rows being the items present in that particular folder.

I guess, you got my point

 

[Jaydw]

Is there a way to pull the data straight from a pst that is no longer
attached in outlook?