Outlook 2003 and Access 2003


T

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
 
Ad

Advertisements

T

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.
 
A

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 :)
 
Ad

Advertisements

J

Jaydw

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top