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