Windows automation

As a vulnerability analyst, I had to send emails about the vulnerabilities discovered during the scans. Since I’d automated most of the vulnerability management and was able to discover much more vulnerabilities than if I was doing it manually, that meant a lot of emails.

I’ve created a program to drive the Excel and Outlook desktop applications, and send hundreds of emails, based on a template and automatically customised for each recipient. This way, the emails were as good as if they had been sent by hand, but boosted by automation.