Windows | Page 3

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

Windows | Page 3

Paste plain text- Use AutoHotKey to strip RTF/HTML formatting

Paste plain text

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!

Paste plain text- Use AutoHotKey to strip formatting

Below is the actual code for doing the above in AutoHotKey.

 

Windows | Page 3

Keyboard shortcuts for launching programs- Start any program with 1 click

keyboard shortcuts

Keyboard shortcuts

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

keyboard 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.

Hotkeys with AutoHotKey

 

Windows | Page 3

Text file explorer-Determine file headers & delimiters without opening file

Text file explorer

Text File Explorer

I often work with large text files in which the file extension (.txt, .dat, .csv, .tab) doesn’t always indicate what type of delimiter is used in the file.  When the file is small, I’ll typically just “pop” it open in SciTE / Notepad.  Large files (anything over 20 megs) often take a fair amount of time to read and very large files ( a gig or more) will often run into out of memory issues.

On top of wanting to know the delimiter, I also frequently want to know what fields / Headers are in the file.   This normally means I have to open it in a text editor or Excel and review.  I wrote the below Text File Explorer in AutoHotkey script to simplify the above.  I can highlight a file from Windows Explorer and quickly detect the type of delimiter plus display headers if I care to.

Text file explorer AutoHotkey code:

Here’s a video demonstrating the usage of the Text Explorer

Text file evaluator-Determine Type of delimiter and File Headers