VBA check for email subject line

[problem_addic]

Is there a way to get access to check to see if an email is present by looking at the date or subject line? If it is there I want to go ahead and kick off an autoexec macro. thanks

[ajetrumpet]

where is the email? in outlook?

[problem_addic]

yes, outlook. It needs to check every 15 minutes.

[ajetrumpet]

i'm not sure if objects that are created in access have timeouts associated with them, but i'm guessing not. never encountered one anyway.

this is going to require a fairly long code module. do you know any library reference coding? microsoft office products all have universal vba libraries, and the programs can all be integrated with each other, but you have to have the library knowledge and integration coding correct. do you know how to do this?

[problem_addic]

I'll do some digging. thanks