Script to monitor Emails and store info in Access database

[melmac]

Hi everyone,

I hope someone can help me with my problem. I was wondering if it's possible
to write a macro script that will monitor incoming emails and send info to an
Access database? To make it more clearer, here's the scenario: I need to
monitor emails wich have the word "Handovers" in the subject line from
specific groups and i'd like the macro script to put a "Yes" on one of the
fields in an Access
database. Is this even possible or do i have to ask someone who's more an
expert on Outlook? Please, i hope someone out there can help me.

Thanks,

 

[consort911]

It's definitely possible (done something similar myself), but all of the code
will be placed in Outlook, I suggest you post there.

Here is a useful link that someone else provided in my post "write text from
emails into table", it won't help you directly, but it will help when it
comes to making the data entry into Access from Outlook

http://blogs.techrepublic.com.com/howdoi/?p=119&tag=rbxccnbtr1

cheers
Brian H

 

[melmac]

thanks consort..
--
"excel newbie"

It's definitely possible (done something similar myself), but all of the code
will be placed in Outlook, I suggest you post there.

Here is a useful link that someone else provided in my post "write text from
emails into table", it won't help you directly, but it will help when it
comes to making the data entry into Access from Outlook

http://blogs.techrepublic.com.com/howdoi/?p=119&tag=rbxccnbtr1

cheers
Brian H