Outlook 2003 and Access 2003

Tony Cannizzo · External Since: Jul 11, 2007 Posts: 6

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 · External Since: Jul 11, 2007 Posts: 6

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.

"Tony Cannizzo" <tcannizzo DeleteThis @bellsouth.net> wrote in message
news:dWsli.52037$Fo1.11472@bignews7.bellsouth.net...
> 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
>
>

amitbhandari · External Since: Jun 27, 2007 Posts: 3

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 Smile

--
Regards,
Amit Bhandari
http://amitbhandari.co.nr

"Tony Cannizzo" <tcannizzo.TakeThisOut@bellsouth.net> wrote in message
news:blrmi.8060$O9.4271@bignews6.bellsouth.net...
> 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.
>
> "Tony Cannizzo" <tcannizzo.TakeThisOut@bellsouth.net> wrote in message
> news:dWsli.52037$Fo1.11472@bignews7.bellsouth.net...
>> 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
>>
>>
>
>