Quote Originally Posted by Abermez
The emails may be read or unread, so it is all emails I want to evaluate.
So on 23-Jul-10 you want to re-evaluate the emails that were sent 1-Dec-08? Unless you are moving the emails to another folder, you need some way to differentiate the ones that have already been processed.

So this code would go into a new module in the Excel workbook?
Yes.

How would I then refer to this function to use it in the dashboard?
Technically it's not actually a function, it's a procedure. You can have a button on a sheet, an automatic trigger when you open the workbook, a custom toolbar - take your pick.

I'm actually heading off on holidays today, so probably will not be able to assist further for a little while. From here:
  • Confirm your logic - EXACTLY what do you want to happen? Think about it as though you were explaining it step-by-step to a child.
  • The code I've provided should give you a good starting point. There are lots of code example on how to refer to Outlook folders, so jump on Google and give it a try. The first test is try to loop through all the emails in your folder, and maybe just display a message box showing the email subject.
  • Try and get as far as you can with the information you have so far. You'll understand it better and retain the information if you try it yourself rather than just have someone write the code for you. Generally people are also much more willing to assist if you demonstrate that you're trying to work it out.
Go forth and code!