Import email and the attachments from Outlook into Access 2007

[EdEarnshaw]

I am creating a database to track contact information. I would like to keep
track and file email correspondence with my contacts digitally (in Access),
rather than having to print off many documents.
I am able to import the emails with the integrated Access 2007 wizard,
however I was curious if there was a way to also import the attachments from
those emails as well.

 

[Piet Linden]

I am creating a database to track contact information. I would like to keep
track and file email correspondence with my contacts digitally (in Access),
rather than having to print off many documents.
I am able to import the emails with the integrated Access 2007 wizard,
however I was curious if there was a way to also import the attachments from
those emails as well.

Your database will bloat if you do that. You could detach them and
put them in a folder on a drive and then link to them. Save the path
in a text field and then format it as a hyperlink.

 

[EdEarnshaw]

Your database will bloat if you do that. You could detach them and
put them in a folder on a drive and then link to them. Save the path
in a text field and then format it as a hyperlink.

Okay. Good point and not something that I had thought about. (Please bear
with me as I'm still quite new to Access.)

Would there be any way to import the emails and add those attachments as
attachments to that record, upon importing the email into the database?

 

[Piet Linden]

Okay. Good point and not something that I had thought about. (Please bear
with me as I'm still quite new to Access.)

Would there be any way to import the emails and add those attachments as
attachments to that record, upon importing the email into the database?

If you write some code to loop over the attachments collection of each
message, you could detach the attachments to a single directory and
write the path to your database. Might be tricky if you've never done
it before, but if you dig around in this NG, there should be code for
most of it here.

Pieter