Link an email to line item in Access

[BaldEagleOne]

I am summarizing a number of emails from a company in an Access database. Is it possible to link the Outlook email to the line item describing it?
Thanks

[June7]

Exactly what do you mean by 'summarizing'? How do you intend to be able to retrieve email? Do you want to save it as a txt file? Then save that file name into a text field of table?

[Gicu]

Are you using Outlook as your email client? One way would be to save the emails as .msg files somewhere in your file system (using a subfolder structure with a subfolder for each CompanyName/ID) and a joining table in Access (depending on your needs the table might not be needed as you can loop recursively through the subfolder and populate a listbox on the OnCurrent event of an company form).
If you want to link the Outlook message itself check out this link:https://stackoverflow.com/questions/...ges-when-email

Cheers,

[BaldEagleOne]

I've attached a jpg of my table which is just summarizing email. What I'd like to do is link each line item to the email in Outlook it represents so I can send the database along with the Outlook file of emails to another person. That person can just be satisfied with the summaries or look at the email, itself, for details.

[Gicu]

When you say "Outlook file of emails" do you refer to a Outlook pst file (not really meant to be sent to other people) or individual email messages saved as .msg files? How experienced are you with VBA? You will need at least a form with some code to do either of my proposed options. Have a look at my free utility that might put you on the right path:
http://forestbyte.com/ms-access-util...ook-companion/

Cheers,

[BaldEagleOne]

Don't know VB. I put a request on your site for some help. Thanks. Let me know if you might be interested.