3 ms·
I was given a spreadsheet with a bunch of data and told I needed to use that data to make a couple thousand Outlook email templates. We started out having inte
by al_borland 3y ago
I was given a spreadsheet with a bunch of data and told I needed to use that data to make a couple thousand Outlook email templates.
We started out having interns do it, but it was taking too long and they were making a lot of mistakes. I ended up writing an AutoHotKey script to copy stuff out of Excel, switch to Outlook, then build the template and save it in the specified format. It required finding a lot of obscure keyboard shortcuts to make it all work, but it got the job done. It was still a bit manual to run, as it was too fragile to let it all go in one go, and I had to watch it. But it turned days or weeks of tedious work into something that only took a few hours once the script was done.