Office


📖 Kb | 📎 Microsoft, Office 365, Software | 🔖 microsoft, office, word, excel, powerpoint

Office 365 Autosave

I am sure that whoever in Microsoft came up with the idea of an autosave flag, they thought it was a great idea. And indeed it is. **However**, when they made it default to _on_, they made a logistical nightmare for the majority of users. This post discusses why and what you could do about it.


📖 Kb | 📎 Development, Microsoft, Software | 🔖 microsoft, office, outlook, vba

Macro to open a web URL from Outlook

Many of us spend most of our work time in a few applications such as Outlook (email) and a web browser. This example macro for Microsoft Outlook will let you add a button to the Outlook Ribbon that will open a specific website URL.

🕑
📖 Posts | 📎 Development, Microsoft, Software | 🔖 couchdb, microsoft, office, outlook

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.

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.

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.


📖 Posts | 📎 Microsoft | 🔖 office, word

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.


📖 Posts | 📎 General, Microsoft | 🔖 facebook, fail, google, microsoft, office

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!


📖 Posts | 📎 Development, Microsoft, Windows | 🔖 maps, office, vba

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. 1. Download Paul Jenkins’s UK Postcode csv and import into Access as a table 2. Create a query on your own table adding the following calculated field: <pre>PCregion: Trim( Left( [My Table]![Postcode], InStr( [My Table]![Postcode], &#8221; &#8221; ) ) )</pre> Create a second query that joins the above query to the imported postcode table.

Copy and Paste to OneNote (AutoHotKey script)

After yesterdays OneNote tool post, 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.

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.