I am sure most of you have to do repititive tasks @ work like writing the same SQL query for debugging a certain issue, creating a particular email template, etc. There are few ways to automate things in individual application like creating a new template in outlook. But if you are looking for a utility which can work across all applications in windows take a look at AutoHotKey.
It is more than text replacement/macro recorder, it includes a nice scripting language which can be used to do almost anything which needs to get done using few shortcut keys. I just downloaded and installed it and started playing around with the .ahk file. I was having so much fun and now I have automated almost all my tasks which I used to type over and over again. I wish I knew about this tool sometime ago. I would certainly say this is one tool any developer should have in his system.
Happy autokeying :)