Hi,

I am looking for a VBA code to monitor whether a response has been sent to all e-mails that has received in my inbox (or any specific folder). I do get huge amount of e-mails (say approx. 500 e-mails in a day) and out of that, I/my team have to reply at least 80 to 100 e-mails. As a large e-mail receiver, I am not too sure whether the required e-mails have been responded.

It would be helpful if a VBA code could help export 'all' inbox items like sender, date/time received, mail subject and add 1 more column to see whether a response has been sent with Sender name, date/time sent (whether me or somebody from my team). I am not looking for the body of the e-mail because I know it will be too complex to put in the excel column. This will help me in monitoring daily e-mail response and avoid certain abrasions from the sender and also going to reduce huge amount of manual search process for e-mails.

I would really appreciate your help on this.