Using Outlook Search Folders to filter only external mail

Following on from my recent post about search folders, I got a few questions and comments via mail. One, from Christian, asked if it was possible to use a search folder to filter out only mail which came from “outside” – eg Only show me the last day’s mail from external senders, thus filtering out all the organisational spam that will typically be clogging the mailbox.

I had a bit of a scratch of the old bonce, and figured out one possible way – there may be others, but none are really obvious. There are a couple of requirements for this to work out, though…

  • Your inbound mail must be handled by Exchange 2003 or 2007, using the Intelligent Message Filter technology to stamp inbound mail with a Spam Confidence Level value. It may be possible to use other tools which also support the Exchange Anti-Spam Framework.
  • You need to install a form into Outlook, which will expose that SCL property which is stamped onto inbound mail. This will then allow you to add the SCL value to views, filters etc.

Once you’ve got the SCL form installed, you can create a search folder with the appropriate length filter (eg all mail since yesterday morning, as described on my previous post) and add a new filter to restrict the SCL value (click on the Field drop-down, and look for either the name you gave the SCL form, or the “Forms…” link to add that).

If you set the filter to be at least “0”, that means that any message with an SCL value of 0 or higher will be shown (you might want to add an additional filter to not show stuff with a high SCL value, since they’re lkely to be in your junk mail folder anyway). You could also restrict which folders are shown, based on the same logic in my earlier post.

Anyway, mail with an SCL value will have come from an external source (ie internal Exchange<->Exchange mail won’t have been scanned by the IMF at all), and will have come from an anonymous connection (mail sent by authenticated servers through the same gateway will be assigned an SCL of -1 to show that it’s exempt from filtering by the SmartScreen logic within the IMF).

It might take a little while to render the search folder if you’ve a large mailbox, but it does provide a nice way of showing you only stuff which came from outside.

//Ewan

You can’t ignore a ringing phone

It’s funny when you look back a few years to see just how communications technology has changed – remember when you might have asked (or been asked), “are you on the phone?”… meaning not, “are you using the phone” but “do you have a phone at home”… now we just assume that (pretty much) everyone’s got a mobile phone, everyone has internet access and everyone has at least one email account.

Organisational culture has evolved a lot in the last 5-10 years, to the point where a lot of people hide behind email while some try to escalate into other forms of communication as soon as possible. There’s one guy at Microsoft who always phones in response to getting an email from me. I tend to enjoy playing cat and mouse by letting the phone drop to voicemail, listening to the message, then emailing him back 🙂

A lot of us have settled on corporate Instant Messaging as a happy medium, for a number of reasons:

  • Like email, it offers access to the whole corporate address book, not just the list of people I’ve talked to before (such as MSN/Live Messenger does) so I can IM people I’ve never had anything to do with.
  • Presence from Communicator is shown in Outlook 2007, and on Sharepoint web sites, so it’s often easier to be context sensitive.If someone’s presence shows up as “In a Call”, there’s no point in phoning them, cos they’re already on the phone (and the status is set by the telephone system, so when they hang up, it’ll revert back to Normal).
  • Best of all, it’s neither as intrusive as a phone, but the immediacy doesn’t get lost as easily as in email.
    • You can’t really ignore a phone that’s ringing – sure, you can forward to voicemail so it doesn’t ring at all, but that’s different.
      • A phone which forwards to voicemail is like the Schrodinger’s Cat experiment in that you won’t know whether you have voicemail – and hence whether anyone was ringing the phone at any given point – until you observe the light on the phone or you actually check your messages. So,
    • When the phone rings, you decide (usually based on the caller ID that’s displayed) if you’re going to answer it, combined with a load of environmental factors (are you busy? are you in a place where you don’t want to take this call? are you just about to go to the toilet so don’t want to be distracted right now? etc)
    • Email, for a lot of people, tends to be like a stack. The last message in (and the one at the top of the list) is the one that gets first attention, meaning it’s easy to overlook stuff that’s in the middle of the stack and probably off-screen when the Inbox is sorted.
  • If someone doesn’t respond to an IM, you generally accept that maybe they didn’t see it – because it’s disposable communication, you don’t tend to have the assumption that a reply is expected. If a sender doesn’t get a response to something important, they’ll always try again, or escalate to another form of communication (like phoning you up).
  • IM makes a great way of starting a side conversation with someone, which might turn into something more formal (escalating to email, to face:face, to group conversations on the phone or even online meetings through the likes of Live Meeting).
    • Often, I’ll see someone’s staus as “In a meeting” – now that could mean they’re sitting at their desk but with Outlook blocking time out of their calendar to do some work (or maybe they’re on a conference call). I’d typically say “busy? got a min?” and if no response comes back, I’d assume that yes, they are busy, and no, they don’t have a min. If a response does come back, then maybe I’ll realise they’re not busy, they’re not on the phone, and in fact, they’d like to meet up for a coffee in 5 minutes.

Interestingly enough, John Westworth IM’ed me halfway through my writing this post to ask a question about my mobile device (an SPV M3100). He theorised that he doesn’t answer his phone much (more through accident than desire, I should add), and figured that I might be the same… so it would be better to IM instead …

This led to an idea for some canny Windows Mobile developer to pick up, and make riches from – an AI-like Bozo Filter for the phone. Just think … it could pick up the Caller ID from an incoming call, figure out if that user is in the Outlook contacts list (or maybe even the GAL) and cross reference with the number of times that individual appears in the Call History (ie have I called this guy before? Has he called me a lot and actually got through?) and in the mail client, then apply a Bozo Confidence Filter (BCL) to the call… which would then allow me to set up rules to decide my preferences for when I will accept calls and from what level of Bozo…

Combine all this with the inherently linear nature of a phone call – it’s synchronous, you (generally) can only have one at a time, and they tend to be fairly short. IM conversations can be done in parallel with each other (though make sure you don’t type a comment into the wrong window by mistake…) and some may have many rounds of dialogue/response stretching over a reasonable period of time (usually at most a day). Email would suit much more asynchronous communications that might be shared with hundreds of people, stretched over any length of time. Choosing which one to use is increasingly a personal preference, and in future, the choice is increasingly going to be with the recipient rather than the sender. So, when the guy I mentioned earlier picks up the phone to call me and I don’t answer, I might receive the call as an IM stream if I’m online and want to take it, rather than dumping straight to Voicemail…

Exciting times, eh?

//E

Using Outlook Search folders to sift large volumes of email

[This is a re-heat and update of an older blog post on You Had me at EHLO!]

Search Folders in Outlook 2003 and 2007 can be a useful tool to manage large volumes of mail in your mailbox; one tip is to create a folder for “all mail since this morning” or similar; I also have a search folder for “all unread blog posts” which means I get a single filtered view, grouped by folder and sorted by date. Here are a couple of examples…

  • Firstly, create a Search Folder by right-clicking in Outlook on the ‘Search Folders’ root folder, and choosing New Search Folder … then navigate to the bottom of the list and create a Custom Search Folder.
  • Click the ‘Choose’ button to start the creation process and give the folder a name (hit the Criteria button on the following dialog once you’ve decided on a name).
  • Navigate to the Advanced tab, and using the Field button, choose Frequently Used Fields -> Received and change the condition to ‘on or after’ and the value to ‘8am yesterday’. Hit the ‘Add to list’ button.
  • Next, choose ‘In Folder’ from the ‘All Mail Fields’ heading within the Field drop down, set the condition to ‘doesn’t contain’ and then follow with a list of words which you want to exclude from the results.
  • Finally, select ‘Message Class’ from ‘All Mail Fields’ if you want to restrict the type of content you’re going to include – I don’t want RSS feeds to be part of the search result, so have set the condition to “doesn’t contain=rss” since the Outlook 2007 RSS form is of message class IPM.Post.RSS.

The second condition here sets the list of folders we want to exclude… I use ‘DL: Sent Junk Draft Deleted’, which means any item in Sent Items, Drafts, Deleted Items or Junk Items will automatically be excluded, but so will any folders which contain the letters ‘DL:’ in their name. This way, I filter social mail and less important Distribution Lists into folders which all start DL: <name> and the other DL items which are more important still show up in the Search Folder.

The last stage is to add the Search Folder to the Favorites Folders collection, and set the default view of the Search Folder to show Arrange by Folder… then it’s really easy to quickly collapse & expand the groupings to show and hide specific folders from the results. Now, all I need to do is get round to reading and responding to all that email 🙂 The sad thing is, that as of writing (around 5pm), the filtered mail from yesterday morning is showing 202 items, 172 of which are unread 🙁

More info on search folders is on Office Online – some here, and here.

//Ewan

Some more useful Windows & Outlook shortcuts

As I mentioned the other day, I’ve a penchant for using shortcuts in Windows: most (if not all) are documented in help files and the likes, but it is amazing how many people don’t know about them or just don’t use them.


Continuing the list of shortcut keys that can save a few fractions of a second each time you use them…



  • ALT-SPACE brings up the menu which allows you to maximise, minimise etc the current window – may be useful if you’ve played with multiple monitors and a window appears half off the screen such that you can’t get to the top of it… ALT-SPACE followed by “M” (for Move) will allow you to use the arrow keys to shift the window around the screen.

  • In Outlook, CTRL-2 switches to the Calendar, CTRL-3 to Contacts, and CTRL-1 back to Inbox. Handy if you’re often flicking around to arrange a meeting with lots of people…

  • Still in Outlook, when viewing the Calendar ALT-= switches to Month view, ALT- “-” (next to equals sign) switches to the week view, and ALT- number displays the number of days forward from the current date (eg ALT-9 will show 9 day view).

There are lots of handy commands which you can type, used in conjunction with Windows-Key-R, to speed navigation in the UI. You could even set up shortcuts to some of these for quick activation using the mouse/start menu etc…


Some favourites:


NCPA.CPL – jumps straight into the network control panel, rather than (depending on which version of Windows you’re running), fiddling about in Control Panel and looking for Networking connections. Under Vista, the guts of Networking is hidden behind the Network & Sharing Center.


DESK.CPL ,3 – (note the space before the comma) – takes you straight to the display settings page that’s used to change resolution, select monitors etc.


COMPMGMT.MSC – quick way of getting to the main Computer Management snapin, which branches off to event logs, user manager etc.


SYSDM.CPL – System Properties dialog (same effect as pressing WND-BREAK)


There are many more – from SERVICES.MSC or EVENTVWR typed directly at the Start menu, to MSTSC /v <server> /console to take over a remote machine’s console using the Terminal Server client.


Enjoy – and Happy New Year!


//E

Mrs Robinson – the finest rhythym guitar you’ll ever hear…

A bit off-topic this, but we had some friends staying over the other night and Julian just took up learning to play the guitar a couple of years ago, and is doing what new guitarists do (I’ve been noodling on all sorts of guitars for about 18 years but can still remember this next bit): voraciously listening to as much as he can, and really listening to the guitar parts. We started talking about some songs that really stand alone, sometimes surprisingly, and I reckon you’ll have to go a long way to beat the multi-layered acoustic rhythym guitar that goes all through Simon & Garfunkel’s “Mrs Robinson”.


Maybe sometime next year I’ll do a “High Fidelity” style list writing exercise… best drum intro (got to be Adam & the Ants’ Kings of a Wild Frontier, surely?), bass line (Floyd’s Another Brick in the Wall?) etc…


Happy New Year!

Some Handy Windows shortcut keys…

I like the Windows GUI, and particularly since I’m use to it, the Vista UI. I don’t think I follow a particularly usual pattern, though, because I tend to make use of lots of keyboard shortcuts which many people may not know, or may know about somewhere in the back of their mind but never bother to use them.

Some examples:

ALT-TAB – cycles through open windows – everyone probably knows that. Yet, I still often see people manually minimising windows to get to the document behind … and wonder “what’s the point of a multi-window, multi-tasking OS if you only ever think about the one at the front?” On a similar vein, SHIFT-ALT-TAB goes back through the list of windows that ALT-TAB does, so if you over-shoot the window/document you’re looking for, it’s quick to go back one.

CTRL-SHIFT-ESC – not that obvious a combination maybe, but they’re at least all down one side of the keyboard so can be quickly activated. Brings the Windows Task Manager up, and a good bit quicker than right-clicking on the task bar, or pressing CTRL-ALT-DEL and getting it from there.

And then there’s the “Windows” key on most keyboards…

  • WND-D “restores” the desktop; ie minimises everything and gives you direct access to the desktop. Annoyingly on Vista, this also minimises the Sidebar …
  • … although WIND-SPACE brings just the sidebar to the fore again, withough making it Always on Top.
  • WND-R is equivalent to the Start->Run command, so it’s only one less keystroke but saves fractions of a second in screen painting time, which always seems like a better way to do it.

There are many other WND-combinations which I don’t really use (like WND-E for Explorer/My Computer).

And finally (for now), one I found out purely by accident by hitting more keys than I wanted on my laptop… WND-Break. Opens the “System Properties” dialog which would normally be on (My) Computer -> Properties from the start menu.

I’ll follow up another time with some other handy commands which can save a bit of time (especially when run from WND-R :))…

Using HTC devices as a modem over USB in Vista RTM

One of the neat things with HTC Windows Mobile 5 devices on Windows Vista is when you activate the Wireless Modem over Bluetooth, Vista will just see the device and automatically detect it as a modem.

When you plug the device in to a Vista PC using USB (having first enabled Wireless Modem over USB on the phone), you may find that it won’t be recognised.

A solution can be derived from http://support.microsoft.com/kb/837637

If you grab your standard HTC USB Modem INF file (you can grab a copy here if you don’t have one to hand) and add the emboldened lines below into the relevant places…

[Modem1.NT]
DriverVer=05/13/1999
include=mdmcpq.inf
CopyFiles=FakeModemCopyFileSection



[Modem1.NT.Services]
include=mdmcpq.inf
AddService=usbser, 0x00000000, LowerFilter_Service_Inst



[Modem1.NT.HW]
include=mdmcpq.inf
AddReg=LowerFilterAddReg

Save the file out under a new name, and when Vista starts looking for the driver, tell it you want to point to a specific location. If it finds this file, you should find that Robert’s your father’s brother!

Have a happy Christmas – see you in the new year!

Keeping my SPV M3100 from getting scratched

 I said yesterday that I had a mixed experience from moving to the Orange SPV M3100 (aka HTC “Hermes”/TyTn design), particularly concerning the size of the device (compared to a regular phone) and the belt clip thing that it comes with.

Jason, however, kindly gave me a present to keep my phone from getting scratched (and keeping it nice & toasty in these cold nights) … an iPod Sock (there’s even DIY knitting instructions if you’re a dab hand with the needles and don’t fancy paying ÂŁ19 for the official one)…

I suppose I should stick in the wash sometime soon as it’s starting to look a little grubby…

It’s almost the perfect size for the M3100 though – it pulls down to almost cover the base of the unit yet still alows a charging cable etc to be used. And it’s often amusing that a guy from Microsoft rocks up and whips out what looks like an iPod… then pulls his phone from the sock 🙂

My Pocket PC kept waking me up with middle-of-the-night reminders… :(

I switched fairly recently from using a Qtek 8500 Smartphone (which I still use occasionally and love for its form factor) to an Orange SPV M3100 Pocket PC Phone, and have had a somewhat mixed experience as a result.


Pros: The M3100 has a nice screen, a slide-out keyboard (making on-the-hoof email and texts that bit easier than Smartphone… though I do like T9 on the Qtek’s keypad). It’s also 3G, which is useful… never really use the WiFi so that’s not a great value add.


Cons: Even with it’s relatively diminutive size, the M3100 is still over-big for a phone. But the biggest annoyance is really with the phone UI – it’s nowhere near as quick to use as a phone, compared to the 8500 … anything that means you need to tap the screen pretty much means you need to be looking at the device and using 2 hands.


Now, a couple of weeks after I got the device I was wakened up in the middle of the night several days in a row, because I’d forgotten to switch it to “silent” before going to bed (not as easy as it might be, since there’s no “Profile” like there is in Smartphone, that could switch between silent/normal/outdoors etc).


I figured “someone must have cracked this!”, and was delighted to find a neat bit of software called PocketZenPhone which not only implements the ability to have profiles (with a lot more than just sound volume etc), but to be able to schedule when the phone switches between them!


 


Now, I have the device automatically go into silent mode at 11pm and go back to normal at 7am… so even if someone sends me a meeting request for a different timezone or something that would fire reminders in the middle of the night, the phone will let me slumber on…


This has to be the best ÂŁ5 I could have spent on Windows Mobile software!

SPAM SWAG up for grabs

SWAG == Stuff We All Get (named after the procedure of getting lots of branded merchandise you didn’t realise you wanted – or maybe don’t really…)

Anyway, for my session at IT Forum (UCM313 – Anti-spam Enhancements in Exchange Server 2003 Service Pack 2), I ordered a load of SWAG to dish out to the audience (the things you’ll do to get a better feedback rating ;-), but since it was all ordered from the US, it got stuck in customs & I didn’t get the stuff in time for going to Barcelona. I had wanted to give away SPAM-branded hats, Frisbees, lanyards, fly-swats (yes …) etc, all ordered from www.spamgift.com – but they never arrived in time!

The coup-de-grace was going to be the SPAM can hat, ably modeled by my buddy Sandeep here…

I’ll send some spare SWAG to the best anecdotes I receive by email or comments through this blog, on how you’re using Exchange to beat the SPAM mail menace… so get thinking!

//Ewan

PS. Top marks to Hormel Foods for embracing the fact that “SPAM” is now as commonly used to describe junk mail as their fine tinned meat product. So many trademark holders crack down on people using their name, yet Hormel seem to have a refreshingly cool attitude to the whole thing…