Tracking email in Access

[PATRICKPBME]

I have an Access form which incorporates a client's email address. Clicking on the link opens up Outlook so I can send the email. I am wondering if there is a way to (1) store and track each email in the database and (2) when the client responds have that response go into the database as well. I am skeptical that #2 is possible but am coming to the experts nonetheless!

Thanks in advance.

[June7]

VBA can extract and save details of email into separate fields (From, DateSent, Body etc).

Access can even link to Outlook Inbox folder.

[trevor40]

Hi there,
You can use VBA to record your outgoing email records in a table. ppl here can probably help you with that.

You will probably need to use VBA code to check an incoming email in outlook, compare it to your list of clients and if listed record the email details. VBA can run in outlook and update access as required. I have never needed to do this, your best bet would be an outlook VBA forum.