How to handle URLs with spaces in Outlook, Word etc

I was talking to a customer earlier today who was envisioning frustrations around using click-to-dial type functionality within OCS, where they’ll be copying & pasting phone numbers around. Now if the number is nicely formatted (and E.164 compliant…) then it won’t be problem, but the nearer number formatting gets to being easily machine-readable, the further it gets from being human-friendly.

This reminded me of a nice tip for dealing with odd URLs or other links (particularly UNC names such as \\server\share\folder name\file name) which might contain spaces. In many applications now (chiefly Word and Outlook, but others – such as Windows Live Writer – support it too), it’s possible to write or paste in a URL and have the application delay processing it and presenting it as a hyperlink.

Instead of ending up with \\server\share\folder name\file name, which you’ll get by starting to type the link, begin it with a “<“, then type or paste the whole URL, then close with a “>”. Now when you press space or enter, the app will likely process the hyperlink, remove the <>s and all is well. If you do end up with a half-formed link, go to the start of the text (before it becomes a hyperlink), enter the “<“, then jump to the end of the hyperlinked text (eg the end of “\folder”), and press backspace – this should remove the active bit. Finally, jump to the end, add your “>” and press space to complete.

Outlook 2007 signatures location

Following my post about .sig files, I had cause to dig around looking for where Outlook actually puts the Signature files. I came across a post which Allister wrote a little while ago, but it’s such a useful little tip that it’s worth repeating…

Basically, Outlook 2007 offers a nice simple editor UI for building your own signatures, however it’s complicated by the need to present the signature in HTML (the default format for mail now), Rich Text Format (aka RTF, the original Exchange/Outlook format dating back to the mid 90s) and plain old Text (with total loss of colour, formatting etc).

image

Outlook actually generates 3 versions of the sig, to be used for the different formats. In some cases – notably with plain text – the end result following the conversion isn’t quite what you’d want… my nicely formatted .sig about comes out a bit mangled, as

Ewan Dalton |     | Microsoft UK | ewand@microsoft.com |+44 118 909 3318 Microsoft Limited | Registered in England | No 1624297 | Thames Valley Park, Reading RG6 1WG

so it may be necessary to do a bit of tweaking to the formats. Do bear in mind, that if you do edit the sig files directly, then go back into the menu in Outlook and make some other change, your original tweaks will be over-written.

Anyway, you could find the signature files in something akin to:

[root]\Users\[username]\AppData\Roaming\Microsoft\Signatures

(there may not be a \Roaming folder, depending on how your environment is set up, or it may be in \Documents and Settings\ and under an Application Data folder depending on your version of Windows).

The lost art of the .sig

Whatever happened to elaborate and amusing ‘.sig’s? It used to be common practice to have a signature with some kind of witty/pithy quote appended at random to every email.

Nowadays, the autosignature that most email programs can insert (such as Outlook’s ability to have multiple autosigs, which vary depending on which account is sending, or whether the mail is a new message or a reply), is typically informative with lots of contact information, job titles, disclaimers etc. I’ve seen some sigs which are twice as long as the message itself (though there may be a legal requirement in the UK to put company information in the sig, in the same way that letterhead paper would, but some people really go to town).

I’ve had a lot of people comment on my own sig (or steal it – you’re welcome to, if you like), since I tried to make it as small as possible whilst still conveying the maximum information, and using hyper links for the different ways you can contact me:

Ewan Dalton
communicator email phone RSS | +44 118 909 3318 | ewand@microsoft.com
Solutions Architect – Microsoft UK
cid:image001.jpg@01C6A4F4.036E8CF0  Sent using Exchange 2007 and Outlook 2007
Microsoft Limited | Registered in England | No 1624297 | Thames Valley Park, Reading RG6 1WG

or for replies (where real estate is even more important)…

Ewan Dalton | communicator email phone RSS | Microsoft UK | ewand@microsoft.com |+44 118 909 3318
Microsoft Limited | Registered in England | No 1624297 | Thames Valley Park, Reading RG6 1WG

Since we’re using Office Communicator, if someone clicks on the first link (the sip: URL), they’ll send me an IM. The 3rd pic (the tel: URL) will call me using Communicator (or whatever else they’re using that can support a telURL, such as a Smartphone).

I kind of miss the days where interesting quotes were de rigeur – you know, the kind of thing about BillG saying 640k should be enough for anyone (I’m not actually sure he ever said that, but we’ll leave it for now) or Thomas J Watson saying there should be a worldwide market for maybe 5 computers…

Speaking of Thos J Watson, if you have an idle few minutes, you really should check out the IBM Songbook – top marks for IBM to keeping it alive as historical curio in the IBM Archives. My own personal favourite is “To Thos J. Watson, President, I.B.M.”, sung to the tune of “Happy Days are Here Again”.

Anyway, last word on .sigs. David Harris, author of the now venerable Pegasus Mail (which had support for auto-insertion or random quotes from a .sig file, used to have a cracker or two. One that sticks in my mind (apparently taken from a real newspaper):

After the boat had been secured above the wrecked galleon, the diving apparatus was set in motion by the Captain’s 18 year old daughter, Veronica. Within hours she was surrendering her treasure to the excited crew.

Thread Compressor for Outlook – do you want it?

Here’s an appeal – nearly 8 years ago, I wrote* a little COM addin for the-then new Outlook 2000, which “compressed threads”. The idea was that it could take an email thread (eg a discussion over a period of time and a number of responses, from any number of people, and typically sent to a distribution list for the purposes of discussion), and compress that thread down to the salient points. It has evolved over a few iterations since but has been largely dormant for the best part of 5 years – it does everything I need it to do, so I’ve never developed it any further (and if truth be told, a hard disk crash blew away the source for the last version and I could never face going back to a previous beta and re-developing the changes I’d made).

I’d like to understand if anyone else would like it.

The basic assumption with Thread Compressor is that when people reply using Outlook, they tend to add all their comments at the top – some do inline replies, but most eschew that – and don’t edit the original contents. If this assumption holds true, then it would be possible to compress all discussion threads down to only holding onto the final email or the final post (to a public folder) since it will contain the entire history of that branch of the thread. Of course, there may be multiple branches of the thread, and Thread Compressor handles that.

The first time many people run TC on a large folder, it will routinely get rid of 50% or more of the content, so proves useful in slimming down folders where you archive stuff, or folders where distribution list contents are sent by Outlook rules, never to be read but to be indexed by Windows Desktop Search or similar.

In my last run, I scanned almost 1Gb of email and the Thread Compressor discovered about 21Mb of mail which could be removed… not quite as dramatic as 50%, but it saved me reading over 1,000 emails and it reduced my mailbox size a little…

There are a few obvious benefits to thread compression…

  • It reduces the size of your mailbox, so keeps you under-quota
  • It removes spurious email so you have less stuff to plough through
  • When searching, it reduces the number of hits since it won’t return every mail in a thread which contains the same word(s)

… but some obvious potential downsides…

  • The assumption at the top of this post. If I reply to someone’s email, but change the contents of their original message in the reply, then TC will retain the modified version and it will look like the originator really said that. There may be ways to work around this limitation now, but I never bothered to figure them out.
  • Legal compliance – maybe you need to keep a copy of every mail for compliance purposes: if so, users programmatically deleting messages could be a *bad thing*.
  • erm, can’t think of any/many more…

If you think this kind of functionality should be either built into Outlook or available as an opt-in addon, then please let me know. We have many thousands of regular users of Thread Compressor inside Microsoft. It would be cool to think of millions more outside as well…

//Ewan

* The really smart bit of TC was actually put together by a guy called Peter Lamsdale. All I did was take his algorithm – which I still have difficulty understanding much less explaining – and strap a UI around it. An earlier version of TC was published (unofficially) on a website and an article was written about it by Evan Morris. There is even an unconnected MSDN bit of sample code which is nowhere near as effective (IMHO)

Outlook 2007 update – performance improvement on large PST/OST files

I’ve been beta-testing this update for a little while and it seems to make quite a difference to the performance of Outlook 2007 (especially at startup) when you have large PST files, or a large offline cache of a mailbox. The Outlook team released it live, yesterday.

http://support.microsoft.com/kb/933493

I’d highly recommend giving it a go – it’s one of those updates where you might not really notice much positive improvement after you’ve installed it, but you do notice that there are less of the times where you notice there’s a performance problem 🙂

Exchange Archiving – to be, or not to be?

A lot of customers have looked at archiving solutions for Exchange over the last few years, and the most common reason for doing so is to reduce the volume of data held on the Exchange server. This obviously brings benefits for the administrators – they don’t need to back so much “stuff” up every night, and they have a chance to use the archive for longer term compliance/discovery purposes. I’ve even seen customers using archives as a way of migrating content from another email system – eg company migrating from Novell Groupwise to Microsoft Exchange decides they would just bung all the Groupwise content into an archive so they can start with nice clean mailboxes on Exchange, but the users don’t lose access to their historical data.

Archiving does pose an interesting question, though – what if you’re just archiving all the garbage that people don’t delete? I’ve seen cases of companies who have an archival solution but have implemented no mailbox quotas, on the basis that the archive takes care of handling everything they don’t want to back up every day. Now this, to me, seems like a situation where the Exchange mailbox stores are going to be relatively static, but the archives are just going to grow indefinitely…

Exchange 2007 Managed Folders

There are some good papers and demos here on Managed Folders in Exchange 2007, and if used appropriately these capabilities could provide a decent alternative to archiving altogether, or could at least provide a way of throttling the amount of junk that ends up in the archive. A nice side effect is that “important” mail is kept online on the server, so is always accessible from any client (without needing to put additional plug-ins or install any other archive-aware software) such as OWA or even mobile devices.

I say this with some personal experience, since I’ve been using Managed Folders for a while now, in the real world. My mailbox sits in the Exchange Dogfood environment where the Exchange development group and Microsoft IT get to implement very early technology before it’s finished, and before it gets rolled out to everyone else in MS, let alone our customers. My mailbox was on Exchange “12” for a year before it released, and it is set to a gut-busting 2Gb quota, so I don’t really need to use PST files any more.

The approach to using managed folders is one where all mailbox content (and it’s possible to differentiate different types – eg having different rules for emails, calendar appointments, voicemail etc) would have some age limit set (eg 6 months), and on expiry of that time, the content gets “dealt with”. This could involve deleting the content, forwarding it somewhere (through journaling, perhaps sending to a different mail system, to a Sharepoint 2007 site, etc), or moving it from the main mailbox folder into one of the managed folders…

 These managed folders are defined on the server and applied to the user via a policy (so that users in different departments might see different folders from others), but it’s important to note that they are mailbox folders (ie they appear as regular-ish folders within the user’s mailbox, are only visible to the same people that might be able to see the mailbox itself – ie they’re not public folders of any sort -and count against the mailbox quota).

Retention limits can be set on both the “regular” mailbox folders (such that after 6 months, everything will get shifted into one of the managed folders), and also on the managed folders themselves… so in this example, everything from the Inbox etc would get shoved into the Cleanup Review managed folder, and after 30 days in there it will be deleted from the server. So the onus is now on the user to decide if they want to keep anything in that managed folder, and if so, move it to one of the other managed folders, which will typically have a longer retention period (eg HR records might be kept for 7 years).

I’d liken this approach to pushing the user into deciding what they need to keep, and basically assuming that anything which doesn’t get specifically tagged or categorised by the act of moving them to the correct place, is therefore assumed to be disposable and can be removed from the server. Of course, it could still be archived somewhere else for long-term storage. It’s a bit like when I was a kid – my mother would periodically come into my room and put anything left lying around into a bin bag and threaten to chuck it out… if I protested, she would retort “Well, if you wanted to keep it, you shouldn’t have left it lying on the floor now, should you??”

//E

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

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

Outlook 2007 caches other people’s calendars

In the default modus operandi, Outlook 2007 likes to be in cached mode when running against Exchange, which is generally a *good thing*. Cached mode means there are (by and large) fewer occasions to go back & forth to the server, as it operates by synchronizing a local copy of the mailbox down to the OST file on the client. This means that operations such as content indexing (which Outlook now does by default), sorting, filtering etc, all happen on the client rather than hammering the server.


Outlook 2003 did this too, but 2007 offers a new capability in caching the calendars of other users on your behalf. Now that’s generally a good thing too – it means that when you open someone’s calendar in Outlook, it adds that user’s calendar to your cache so that you can see it when offline, and if it’s someone you regularly snoop on (let’s face it, a lot of calendar lookups are just checking what people are up to, aren’t they?), then it will be quicker in opening the calendar in future, since Outlook doesn’t have to go back to the server for everything.


A possible downside to this is if you’re in a large organization and you routinely (but occasionally) open lots of people’s calendars – what then happens is that Outlook spends time and increases the size of your OST by dragging everything down to your PC.


There are a couple of options to mitigate this potentially unwanted behaviour:



  • Remove unwanted calendars from your list. If you go into the Calendar in Outlook, you might see a large list of “People’s Calendars”, meaning you’ve viewed them before. You could right-click on each individual calendar on the list and choose “Remove …” and it will ditch that item from your list and also stop synchronizing it (assuming you want to continue synching some other calendars), or…
  • Go to Tools | Account Settings | double-click on <Exchange Server account> | More Settings | Advanced  and clear the check-box which says “Download shared folders…”



If you’re experiencing problems with excessive calendar synch traffic, one of these options might sort you out…


//Ewan