Transfer Systems regardless of their sources
Our clients enter campaigns into a SharePoint page that need to be transferred to our CMS. Unfortunately the two systems are not tied in any way and there are no existing API Web Services that we can leverage.
There are over 250 items that might be selected which means we end up taking a lot of time to, manually, transfer the campaigns.
I wrote a script with AutoHotKey that automates much of the process (as well as replacing Unicode values with their HTML equivalents). This allows me to transfer systems automatically with very little effort!
This saves a TON of mundane time by performing web scraping with AutoHotkey and is more reliable than doing it manually.
Automate sales emails
I know a lot of very hard-working, but non-technical, sales people. They spend a lot of time writing personalized emails to clients and spend even more time trying to track the responses.
There some decent mail merge tools on the market however they can be somewhat technical to use (and easy to mess up). I built a short script in AutoHotKey which allows for automating of emails but allows fore proofing & tweaking before deployment.
I (like everyone else in the world) frequently copy-paste between various programs. While some programs like Word and Excel allow for paste plain text, a lot do not.
Paste plain text
I wrote a small script in AutoHotKey which takes the contents of the clipboard and strips it of HTML/RTF format. This way it allows me to paste as plain text in any program by hitting a key combination (Control+G). What’s great is that I don’t actually lose the original format so, if I decide I actually wanted the original content, I can still just paste with Control+V and I’m good to go!
Below is the actual code for doing the above in AutoHotKey.
^g:: ;Control G =Paste Text version of Clipboard
Store:=ClipboardAll ;Store full version of Clipboard
clipboard = ; Empty the clipboard
SendInput, ^c ;copy highlighted text ;SendInput to Send if you have issues
If ErrorLevel ;Added errorLevel checking
MsgBox, No text was sent to clipboard
SendInput, ^v ;paste plain text ;you might switch SendInput to Send if you have issues
Clipboard:=Store ;restore clipboard to original content
Keyboard shortcuts can be a great time saver (especially for specific programs, folders, actions) that you do dozens of times a day.
Over a decade ago I put the below file together documenting the most frequently used Windows / Office shortcuts
MS word file great keyboard shortcuts
Now-a-days AutoHotKey to create my own shortcuts (of which I have over 100 which do various activities by a simple click of the key/button.) AutoHotKey has a function for this called Hotkeys which are a great way to launch programs / scripts /folders that you use frequently.
This video walks through how easy it is to set up hotkeys to launch programs, scripts, etc.