Import email and the attachments from Outlook into Access 2007

  • Thread starter Thread starter EdEarnshaw
  • Start date Start date
E

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.
 
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.
Click to expand...

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.
 
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.
Click to expand...

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.
 
Piet Linden said:
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.
Click to expand...

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 said:
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.
Click to expand...

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?
 
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?
Click to expand...

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
 
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?
Click to expand...

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
 
Back
Top