Monthly Archive for August, 2007

Outlook 2003/2007 SQL Search Folders

Published
by
Bret Fisher
on Aug 30, 2007
in Microsoft and Solution Writeups
. 0 Comments

Outlook Search Folders can have a SQL-like structure for filtering the contents. I wanted a search folder that would show me anything in any folder over X months old, since my office blocks the use of .pst or archive’s, I needed a semi-automated way to clean things out of project folders and the like.

  1. Create the search folders and focus them on just the mail folders you want to search, don’t worry about the filter so just chose a simple one.
  2. Outlook 2003 users will see the SQL tab when customizing the search folder, but it’s hidden and annoying in 2007. Thanks to Andrew Delin for pointing us to how to see the SQL tab in the “customize this search folder” screen: basically customize your button bar and add View>Filter as a button. Then click on a search folder and click the Filter… button to see a SQL tab for entering this info.
  3. I wanted to search back six months, so this is my sql statement. the number is the seconds from today (60s*60m*24h*6m):

“DAV:getlastmodified” <= today(-15552000)

Another cool search folder filter based on conversations over at on20.net. More date examples at Andrew Delin’s WebLog.

SBUX

Published
by
Bret Fisher
on Aug 14, 2007
in Life
. 0 Comments

In researching Starbucks overseas, I googled onto these pictures of Starbucks around the world.

Becoming a runner

Published
by
Bret Fisher
on Aug 14, 2007
in Life
. 1 Comment

I’ve been on a treadmill or on the road 5 days or more a week for most of 10 months. Using tools like Nike+, iPod, and Spark People has helped make the last 40 pounds melt away. I’ve got 30 more to loose before I should be around %15 body fat. I’m finding that controlling my intake to 1500 calories a day is harder then burning 500 off a day. Ever since reading Ron Brown’s book I’ve been determined to be in a negative calorie mode each day of -1000 kcal’s. That should get me close to loosing 2lbs a week, but often I’ll eat a big meal, something fried, or sweet… and end up only -500. I’m confident that it’s a lack of competition that prevents me from really going for it.