email directly into Access Record

[bkelly]

Just pondering here, but:

Is there a method to route an email directly into a record within Access?

I am thinking of an Issues monitoring system (Found a template for just this on line.) Can Outlook send the body of an email directly to Access so that it would become a record (maybe I should say tuple) within a table? I found discussions about sending emails from Access, but not about receiving into Access.

 

[SydneyGeek]

You don't need VBA to run that check. You can use a COUNTIFS formula in Sheet1, and filter for zeros.
In F2, something like:

=COUNTIFS('Sheet2'!B:B,A2,'Sheet2'!C:C,"Re: "&C2,'Sheet2'!E:E,"<>"&E2)

Fill down

Denis

 

[parth007]

Hi Denis,

Its not working..

cant we have a VBA code to highlight those emails which are in inbox but not yet responded...
Any email tracker

 

[SydneyGeek]

What do you get with the formula? Do you get all 1 or all 0, for something else?
There is no reason why it shouldn't work.

Is there a reason why you are doing this in Excel? I assume it's Excel because you mention Sheet1 and Sheet2.
If it's Access, let me know and I can help you build a query to find the unresponded emails.

Denis

 

[parth007]

Hi Denis,

Surely will let you know soon, i am in a process to structure the flow as i am not getting full control of code as planned..
Will change the sources... thanks for it.. if in case i come across access i will surely let you know.. have a grt day

 

[larryt1940]

I have a project that can use the code with some modification.
How could I modify it to write only the Date & Time Sent, Subject, and each individual url contained within the body of the email as a separate recordset in access 2010?
There is no fixed number of http urls. Each email contains links with anywhere from 1 to 6 urls and each url would be a separate recordset with the same timestamp and subject.
Would the emails have to be in a specific format, i.e., RTF, HTML, or Text?
Thank you for your help.