I was hoping someone here could help me out. I have Excel macros to email a hundred or so reports. My problem is the Sent Items folder in Outlook 2013 gets almost unmanageable if I don't go in and delete all the reports that were sent. I looked at options to create a rule but there are some drawbacks and I don't want to go that route. What I need is a simple macro that automatically runs when email is sent to check for specific text in the subject of the emails. Then delete only those emails from the sent items folder in Outlook. I assume that Outlook has something similar to Excel's ThisWorkbook where a macro can automatically run when an email is sent. If there is a method that can be added to the Excel code, that could work as well. But I don't know if the Excel code can monitor the Sent Items folder in Outlook.
I do not want to turn off the option to retain sent emails in Outlook, I just want specific emails deleted when they occur. Maybe the option to retain sent emails can temporarily be turned off when the reports are sent then turned back on afterward ?

I'd appreciate any help that can be given.