Reply to last sent Email with Trail Mail - In SENT ITEM

Hello Experts,

Require your assistance in making a VBA code for below requirement.


In a day user emails to a group which have subject line for example "Score Status"
User sends mail at 1:00 PM then 2:00 PM and so on - Hourly Mails. having subject same.. i.e. the mail which have trail mail start from 1:00 PM till last sent mail.


We need a VBA code which will ask for Subject in a Popup Box or a Cell range after which the code will search the last sent mail in Outlook & open that mail with reply to all option..


Please assist

I tried searching google.. with no luck

Any idea or script which can be useful on this.. please let me know

This is the code which i got in google.. Dont know how to make that work for me.. as i want to check for last sent mail & then reply all to it..

Please Login or Register  to view this content.