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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1

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.

blackbox wrote:
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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1

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" wrote:

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.

blackbox wrote:
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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1

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

steve_doc wrote:
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

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.

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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1