Outlook COM addons + AutoHotKey was one of the ways that I learned programming back in the day. Email arrives > check the sender > if sender is $company > check for keywords and then run excel macros based on that > generate PDF report and automatically generate an outlook email, attach and send the file.

Good times, it feels like we're getting less and less flexible with the hackability of our corporate workflows as time goes on.

so true - I use some outlook vba to send mass emails programmatically