Office

2014-06-27 Outlook 2013 URL Protocol Handler

Outlook has a custom URL protocol that allows interaction with different elements such as folders, mail and calendar items and contacts, Since Outlook 2007, this has been restricted for use only within Outlook itself but there are some tremendous opportunities for use from simple web systems. This post explains how to turn it on, even for Outlook 2013 (Office 365 version). It also gives pointers to other articles on how to use the protocol.

2012-09-12 Microsoft 64-bit Application Support (lack-of)

Microsoft's 64-bit support is still sorely fragmented as we find out with a brand new laptop trying to access Microsoft SharePoint.

2011-12-23 Low-cost Information Management, Communications and Collaberation Tools

Although much of the work I do is for very large organisations and extremely costly projects, being an adopted Yorkshire-man, I’ve always an eye open for a bargain! More seriously, there are many small to medium sized businesses and charities that cannot afford big IT budgets but that still are crying out for good information management, communications and collaboration tools. In this article, I’ve tried to highlight a few tools that I think are worth looking at.

I’ve not included anything in this article that requires a monthly or annual cost. All the tools here are available for free at least with limited features. The feature lists given are for the free versions with paid-for key features noted where appropriate. I also note if any of the web sites are blocked by typical enterprise firewalls.

There is a lot more than what I’ve shared here, I’ll try to update this article from time-to-time.

2011-12-20 Microsoft Word Wildcard and Regular Expression Search and Replace

One often missed aspect of the Find dialog in Microsoft Word is the ability to use wild cards.

In fact, Word not only has the simple wild cards (* and ?) but uses simplified Regular Expression (REGEX) searching.

In this article, I’ve put together a number of examples of advanced finds and replaces that I’ve found useful. I’ll update it from time to time.

2010-06-13 Microsoft’s Facebook Docs.com fails at the first hurdle

Had my first test for Microsoft’s new docs.com this week – and it failed badly. In case you don’t know, Microsoft recently announced a new beta Office Live link-up with Facebook. You can log in using your Facebook login instead of a Microsoft Live Id. So you would think that it would be possible to use docs.com as a collaborative document editor and I suspect that you are supposed to be able to – as long as your documents don’t contain anything complex – such as comments!

2009-09-29 Nearest Postcode Search in Microsoft Excel

I need to find a load of addresses by proximity to a postcode. I have the addresses in a Microsoft Access database. Download Paul Jenkins’s UK Postcode csv and import into Access as a table Create a query on your own table adding the following calculated field: PCregion: Trim( Left( [My Table]![Postcode], InStr( [My Table]![Postcode], ” ” ) ) ) Create a second query that joins the above query to the imported postcode table.

2009-04-01 Copy and Paste to OneNote (AutoHotKey script)

After yesterdays OneNote tool, I thought I’d do another while I think about it. Another annoyance of OneNote is it’s lack of control over pasting information from the clipboard. I’ve raised a suggestion with MS to improve this; you can see my comment in the newsgroup. To ease things a little if you need to copy and paste lots of stuff to OneNote, here is an AutoHotKey script to help. You need to assign this to a hot-key and have OneNote open in the background.

2009-03-31 Setting list item gaps in Microsoft OneNote (AutoHotKey script)

Although I like Microsoft OneNote and use it continuously, it does have a few failings. One of these is the inability to set the default styles and layout for text. In particular, when you create a new paragraph or list entry in OneNote, the default – non-changeable – setting is to have no white space between the paragraphs. This is very poor design and makes more than a small amount of text quite unreadable.

2009-03-17 Critical Bug in Outlook 2007

I’ve recently stumbled on a bug in Outlook 2007. Apparently it is quite well known and the only reason that I hadn’t found it was that I don’t use Outlook as my main email client. In fact I only use email on it to handle meeting requests. The bug is that Outlook 2007 ignores the setting regarding sending reply requests for IMAP accounts. If this seems rather irrellivant to you, you might want to think again.