Now *that’s* a user scenario…

Try this. Open up word, make sure automatic spellchecking is on, and type in the names of some star wars characters:       I love it. They’re in the dictionary… except, for some reason, for Leia. For the ones it does know, it even capitalizes the first letter for you if you type it…

1

Sort data in Excel in "High, Medium, Low" order

Occasionally I have data that looks like this, sorted on the “Value” column: It’s always annoyed me that Excel couldn’t read my mind and figure out that I wanted to sort them in “High, Medium, Low” order. Recently I found out that it is possible to do this by creating a “Custom List” in excel:…

2

Get text pasted into Word/Outlook to format properly

If you’re like me and do a lot of copying content from other applications into Word and Outlook, you’re probably very accustomed to using the paste smarttag to choose whether or not to use the source or destination formatting on paste. If you’re tired of constantly switching it and want it to use the right defaults,…

3

Count the number of folders in your mailbox with Outlook VBA

A coworker asked me today if I knew how to count up the total number of folders in his mailbox, in the process of troubleshooting a bug related to having a large number of folders. I had an old script that recursed through a mailbox to count the total number of items (also written for…

2

Least obvious yet terribly useful Outlook/OWA calendaring feature…

While reviewing some custom OWA themes we’re developing, one of the designers pointed out this odd orange mark halfway through one of the numbers on the calendar view, wondering if it was a bug in the CSS in the custom theme:  Actually, it’s one of these tiny little details that I think is so slick -…

2

Quickly view the internet headers of a message in Outlook

Just about anyone who runs mail servers needs to look at headers from time to time. This is especially true during the development of product such as Exchange, as we track down and fix bugs. I wrote this little macro to make that a little easier. Select a message, click the button to run the…

8

Show the count of all items in a folder in Outlook, not just unread

For certain types of folders, you may find it useful to have the folder list display the total number of items in the folder, not just the unread items (which it does by default). For example, I set this on some folders that contain messages to certain distribution lists, where there will always be threads…

6

Cheat Sheets

While ego surfing I just ran across this handy list of cheat sheets that I wanted to share. Covers topics from HTML to networking to office apps to keyboard shortcuts to SCSI to math. Handy.

1

Configure Sharepoint 2003 to store versions of your documents

My relationship with Sharepoint is a love/hate story. I’ve been using it since its original incarnation as the “departmental server” many years ago (trivia: and it was built on the Exchange store), but not heavily until the last year or two with SPS 2003. The first six months I [was forced to] use it, I…

2

A poor man’s mail merge

Several times in the last few months I’ve needed to send the exact same mail content to a list of people, but each mail had to be separately addressed, for the following reasons: I am expecting each recipient to reply and continue the thread with me. This way there’s no risk of “Reply All” going…

3