Autohotkey vs Caps Lock


Caps Lock

I was hunting for a way to get rid of the issues that I was having with CAPS LOCK !!

I hit the key without realizing all the time. As I try to move closer and closer to pounding out documents and code the frequency of caps lock abuse has increased.

So my mission

Neuter the CAPS LOCK

So the simple solution is to pull the dang thing off, but there are better ways, as you may at some point want to use it. Or why not use it for something else.

So I found an answer : AutohotKey


What a great APP!

Not only can you change the key to something else, you can make a SHIFT CAPS LOCK actually turn it on!

And then it hit me, That I could use this tool for much much more….

For One, I use GMAIL. I love gmail, but why it does not have a reply signature or proper html / rtf signatures I will never know. So I added CTRL + ALT + S to insert my signature

I also added ty -> Thank You

yoiu -> you :: My biggest and most common typo..

CTRL + ALT + M : to open my email

yt =

Yours Truly,


ty = Thank You.


Ok -> OK another common typo / brain malfunction

There are many many more uses here is an example of parts of my script :

Most of these are direct grabs from the website  :



;^!w:: msgbox, WinActive ahk_class



IfWinExist Untitled – Notepad



          Run Notepad



; Only allow capslock if it’s shift-capslock




   if caps = D




; ———————- EMAIL SIGNATURE ———————-


#IfWinActive ahk_class Chrome_VistaFrame


Send — {Enter}

send ~~~~~~~~~~~~~~~~~~~~~~ {Enter}

send Fraser Dowall {Enter}

send {Enter}

send {Enter}

send {Enter}

send ~~~~~~~~~~~~~~~~~~~~~~~ {Enter}





; ———————- EMAIL SIGNATURE ———————-

; ———————- ————— ———————-

; ———————- EMAIL SIGNATURE ———————-






::ty::Thank you

::sig::Thank you,{enter}Fraser

::yw::You are welcome,{enter}Fraser


; tip#3 – Adding the timestamp quickly while taking notes


FormatTime, CurrentDateTime,, M/d/yyyy h:mm tt  ; It will look like 6/29/2008 10:35 AM

SendInput %CurrentDateTime%



Is the IPhone ready for business?


Is the IPhone ready for business?

For those who know me I go through a lot of tech, and very fast. I’ve had, or tried out just about every phone technology out there.

The 2 winners so far wereiphone_home

1) Symbian OS on a Sony Ericsson P990

2) Windows Mobile on an HTC

I loved some of the multitasking and interactivity on the Windows Mobile suite but the OS seemed too large for the hardware that I was running it on. It reminded me of when Windows 95 came out and everyone was trying to run it on their 386 machines.

Plagued with daily re-boots and the machine not being fast enough to switch to phone mode in order to answer an incoming call, the device quickly became a fantastic GPS and PDA, but as a phone it was lacking.

I decided to give the IPhone a try.

So the quick answer: as a phone the IPhone is awesome. Free updates, Applications galore.. have you every heard of Windows Mobile having a free automatic update?

So what is it missing, Well both the IPhone and the Windows mobile device fail when it comes to long distance calling cards, I’m not sure why neither  of them have figured this out the way that the Symbian OS has done since the start. You can use 3rd party apps on windows mobile to get the same functionality, but so far I have not found the perfect app for the IPhone.

The IPhone also does not support exchange calendar invites, this is a huge miss, for business I have to go online and open the attachment in notepad or equivalent to try and read it, although Google seems to have figured this out for the calendar app.

Cut and Paste, yeah we are still waiting for this pretty basic feature, although, I will admit to having only needed to use the feature a couple of times…

I am very happy with the IPhone though, it is by far the best overall phone that I have ever used, the big screen, one button interface has so far won me over. I can’t wait for the next set of updates and perhaps a tomtom app on the IPhone to complete the win for me. As for the lack of real push email, I’m not sure that I miss it as a feature, and even more, I’m not sure if I believe that it is necessary. I mean is it email or SMS?

Please IPhone let me choose custom message sounds and email sounds though.. this is really missing. As well as customize the backgrounds and look and feel without jail breaking the dang thing.

Winner so far – IPhone – I am able to do my business and I use IMAP to keep my world in sync.

Getting Things Done

getting-things-doneMany people ask me about technical skills and training. What I do not hear much of these days is requests for some of the more basic ‘SOFT’ skills that help everyone on a day to day basis. Everyone would like to think that they are efficient users of time, organization and email. The truth, however is that most people struggle daily with their task lists and get stuck up in E-Mail Hell and have what I like to call Email anxiety (Not sure where I heard that). But the truth is that we either push everything in rules to folders or we archive it so it’s there somewhere, but we always wonder if we did in fact respond to X.

One easy way to see if you are one of these organized email keepers or not, is to check and see if you have ever asked someone for an email or information, only to have them forward an email that they had already sent you containing the information.

More on Email later…

A few years ago I started re tooling my time management. I decided to use a technique that I found on one of my favorite blogs.

David Allen’s book “Getting things done”, “The Art of Stress-Free Productivity” has led to some significant ways that I organize my tasks emails I highly recommend buying his book and trying it out for yourself.

Alternatively there is an Audio book version that may be more handy for those who prefer to listen! 😉

Links :


Converting a date CYYMMDD to and from


I ran into a customer using the old Y2K Date that I hhadn’t seen for a while and thought that I would take a moment to blog how to convert to and from.

TO : 



 ELSE ‘0’ +




Convert(DateTime, Convert(VarChar(8), EV200_START_DATE + 19000000))