Check for specific email in Outlook

[blackbox via OfficeKB.com]

is it possible for excel to monitor emails (in Outlook) and if subject =
"XXXXX" and date received = Today() then put time received in cell A1?

 

[blackbox via OfficeKB.com]

or another approach, maybe something like a DDE link the will show the most
recent email. maybe subject in 1 cell and date/time received in another cell.
then i could write something to check for matches.

 

[Guest]

Hi

I wrote and use on a daily basis a similar tool to access Lotus Notes
main difference is I extract all emails for a given date and process from
their

To "moniter" would more than likely require use of a timer event

Basic automation of Outlook see the following sites

http://www.excelkb.com/?cNode=5V1C8G&pNodes=0U7Q0Q
http://www.freevbcode.com/ShowCode.asp?ID=1469

HTH

 

[blackbox via OfficeKB.com]

Thanks! I'll read through it

I usually receive 100 to 150 emails each day but i could work with all emails
being extracted to a second sheet and then sort them


thanks again