Saving mails in Access

[kbsudhir]

I want to store the mails I receive in Outlook 2003 in Access 2003. I am able
to capture all the attributes of the email including body in diffterent
fields in the database but my requirement needs to store whole mail as an
object in the database. I have created a table with field with datatype "OLE
Object", but to capture the mail in that field, I have first manually store
the mail in a physical location, then manually from the table I have to
insert the mail to the field.

My question can we automate the same directly from outlook without saving in
the any folder(even temporarily). If yes, how to do it......????????

Any help regarding the same is appreciated.

 

[Tom van Stiphout]

I don't think so. But with the temporary table you already have a
good solution.
The other alternative is to leave the email where it is (perhaps copy
to a public folder), and only save a pointer to it in your database.

-Tom.

 

[philippou spyros]

I want to store the mails I receive in Outlook 2003 in Access 2003. I am
able
to capture all the attributes of the email including body in diffterent
fields in the database but my requirement needs to store whole mail as an
object in the database. I have created a table with field with datatype
"OLE
Object", but to capture the mail in that field, I have first manually
store
the mail in a physical location, then manually from the table I have to
insert the mail to the field.

My question can we automate the same directly from outlook without saving
in
the any folder(even temporarily). If yes, how to do it......????????

Any help regarding the same is appreciated.

 

[kbsudhir via AccessMonster.com]

Thanks Tom, but how to save the pointer...??
I want that when I click the pointer the saved mail should be opened.