Automate sales emails with AutoHotKey and Excel


Automate Sales emailsAutomate 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.

Automating Sales emails

select multiple items on a form (in mass)

select multiple items

In order to speed-up our page load times I like to archive items to an old folder.  Unfortunately there is no easy way to select some, but not all, items.   What I really wanted to do is automate select multiple items from a list.

Web scraping with AutoHotKey to the rescue!!! This simple looper is fast, flexible and a life saver. It simply sends tabs and the space key to my browser window saving me a lot of time and mundane work.  Below is the AutoHotKey code which is set to work in Chrome

And here is a video in case you’re not getting the value.

Select multiple items from a list

Selecting / Deselecting items on a form (in mass)

HTML Testing & URL Verification tool with AutoHotKey and Excel

URL verificationURL Verification

Working in Internet Marketing I’m frequently involved with reviewing new and active web pages.   When I started the process was manual and quite time consuming so I wrote a script to automate much of it.  This video demonstrates it in action.  It requires you to navigate in IE (yes, I know…) and uses Microsoft COM to rip all the URLs by web scraping with AutoHotkey from the active page and dumps them into a spreadsheet for URL verification.  It also pulls things like the title of the page, # of words on the page, most popular words,  Values for name and ID elements as well as the actual URL and outerHTML.

The script also allows you to choose your overall area which is great because there is probably a template that your company uses (and you’ll probably want to exclude items that are part of site navigation, not unique to that particular page.

HTML – URL Testing & Validation tool


Remove duplicates from CSV files in a flash with an AutoHotKey script

Remove-DuplicatesIn email marketing I am frequently having to remove duplicates.   I typically used Excel for this but I did it so frequently I built a small script to automate the process.

The program requires a CSV file and utilizes Microsoft’s Component Object Model to open Excel and examine the headers for a field named “email”.  Once it finds it it removes duplicate email addresses and saves them as a new file in the same folder with the naming showing how many rows are present.   This greatly reduces the amount of work needed to do the job.
This should ease the removal of duplicates from CSV files.

Remove duplicates demo video

Removing Duplicates from CSV files