I am designing an Excel dashboard to monitor my team's daily operational activities.

One of their tasks is to send a series of emails throughout the day with specific headings and attachments. I am a recipient of each of these emails and so I have to check my "Business Management\MI" Outlook folder (I have an Outlook rule that sends these emails to that folder) to see whether they have sent each one.

However, I want my Excel dashboard to present a real-time (or button-triggered, if necessary) summary of whether each email has been received at the time of refreshing the dashboard (or clicking the button).

For example, the emails in my MI folder could be:

Subject: Email A - Received: Thu 15/07/2010 10:12
Subject: Email B - Received: Thu 15/07/2010 09:36
Subject: Email C - Received: Wed 14/07/2010 14:57
Subject: Email A - Received: Wed 14/07/2010 14:30
Subject: Email D - Received: Wed 14/07/2010 13:52

So I want my dashboard summary to show:

Thursday 15 July 2010
Email A: Sent 10:12
Email B: Sent 9:36
Email C: Not yet sent
Email D: Not yet sent

I've searched the 'net for a couple of days now but haven't found what I'm looking for, and what I have found hasn't worked.

I'm using Outlook 2007 (v12) and Excel 2002 (v10).

Any help gratefully received!

Thanks