Hello all,

I am trying to write a VBA script for an Excel document. I receive the same email five times a day and it is automatically stored in a folder in Outlook (let's call this folder "Special Reports"). The emails all have the exact same subject line (ex: "Quality Report"), but each one has an Excel attachment that is updated as of the time that email is generated.

What I am trying to accomplish is to have Excel automatically open the most recent email from the "Special Reports" folder and open the attachment into Excel. I do not need it to open all of the emails that are unread, only the most recent. I do not have the code I have been working on with me, but the part that was giving me the greatest difficulty was writing the code to search for the email in the folder and not the inbox.

If you are curious, I am using Office 2007. If you have any other questions, feel free to ask.

Thank you!