TryCatchFinally.net Some SQL, some .NET, and whatever else

About Me

My name is Ryan McCauley, and I'm a database developer trying to bridge the gap between the developer and the business. During the day, I'm the lead developer at a mid-size cable TV provider, and I spend my hours there doing T-SQL development, dabling a bit in VB.NET, and generally trying to make SQL Servers run as well as they possibly can. On my own time, I write small utilities to make things a little easier to do, as well as small consulting jobs. I've posted two of those utilities on Codeplex:

SQL Server Contention Monitor - Show real time process blocks and block trees on SQL Server
SQL Space Map - Shows data spaces visually, including index sizes for each table

If you have any questions, please let me know, and I'll be happy to answer them!

I also enjoy spending time either learning or trying to solve problems - check out my Stackoverflow.com profile.

profile for rwmnau at Stack Overflow, Q&A for professional and enthusiast programmers

I'm also on Experts-Exchange with just over 1 million points, answering questions about .NET and SQL Server.

Comments (2) Trackbacks (0)
  1. Hi Ryan,
    I’m a brand new VBA user and happened across the macro built for delaying the sending of messages in Outlook 2010 – http://superuser.com/questions/628983/outlook-change-default-email-delay-for-do-not-deliver-before-feature
    This will CHANGE MY LIFE, but only if I can get it working. I’ve copied the code found here – http://trycatchfinally.net/Downloads/DelaySendMail.txt into into VBA and even pinned the shortcut to my qucik access toolbar. But something must be wrong – it’s not working. I don’t like to think that I am in over my head, but I’ve been beating my head against the wall over this for a couple of hours now. Any advice you can offer to help solve this?

    • This code has been great for me as well – I try to encourage people around me to take some time off after hours, and I don’t want my late-night emails to have them worried, so I often end up delaying delivery until first thing in the morning. I’m glad to hear that you’d find the code useful too (if it would only work)!

      Have you followed the steps on the MSDN walk-through I linked in the original post? In particular, the steps you’ll want to follow are in the section called “Making Macros Accessible”:

      http://msdn.microsoft.com/en-us/library/office/ee814736%28v=office.14%29.aspx#sectionSection3

      Alternatively, you can place a breakpoint on the first line of the sub and then press the quick access button you’ve set up – if the code is being called correctly, you’ll get a debugger in VBA on that breakpoint line. If you get the debugger, then there’s some reason the code isn’t working, and I’m happy to help figure out what it is. If you don’t get the debugger, then the code likely isn’t pinned to the button correctly, and I can try my best to help you figure that out as well.

      Good luck!


Leave a comment

Why ask?

No trackbacks yet.