Moving from Outlook (Exchange) to eM Client (Google)

For the last 14 years I’ve used Microsoft Outlook to manage my life. Last week, with some trepidation I moved to Google (Gmail, calendar, and contacts) and something else for tasks (I’ve not quite settled on it, although Todoist is currently a very strong contender). I thought it may be useful for others in a similar situation to document my experience.

Over the years I have used Microsoft Outlook 2000, 2003, 2007, and most recently 2010. I have synchronised it with various Psion handheld computers, with Windows Mobile, and I’ve used it for the last four years with a hosted instance of Microsoft Exchange 2010 from the excellent, UK-based Simply Mail Solutions.

ActiveSync kept sinking

I moved to Exchange in 2010 mainly because I was having issues synchronising my Windows Mobile phone via ActiveSync with two PCs: home and work (below). Synchronisation didn’t always work successfully and I had no end of problems: duplicated, missing or deleted content. Enough was enough, so I looked at the options.

Workflow for using ActiveSync with two instances of Outlook
Workflow for using ActiveSync with two instances of Outlook. I found this caused all sorts of problems when using the phone as the ‘golden copy’.

Move to Exchange

At that point, in 2010, I considered moving to Gmail but Windows Mobile 6 didn’t support Google data particularly well and I had no real need to share my data with anyone else but myself. My main concern was synchronising data between devices not between people.

So I research the options and in the end I moved to an Exchange 2010 account rented from Simply Mail Solutions. It cost me around £70 per year, plus my domain name. But I felt that cost was worth the expense when set against lost time and frustration due to synchronisation failures.

Synchronisation with Exchange Server 2010
Synchronisation with Exchange Server 2010

With this model everything was synchronising with the Exchange server in the cloud. It was fast, it was efficient, and I never once had an issue with duplicated or missing content. I could add a task on my phone during my walk to work and when I got to the office it was already there on my PC. It felt like magic.

When I moved away from Windows Phone a few years ago and bought a Google Nexus 4 it had support for Exchange under its “Corporate” account settings. So, again, there was no need to move. If it ain’t broke…

Why move to Google, then?

What has changed recently though is that now I do need to share my data with (my wife) Jane. To add another user to Exchange was going to be expensive and unnecessarily complex, particularly when you factor in which domain names we use and that Jane was already using Google mail. The logical conclusion was for me to move to Google.

eM Client for mail, calendar and contacts

One of my hesitations about moving lock, stock and barrel to Google was that I’m not particularly fond of the standard Gmail or Google Contacts interface; Google Calendar is okay; Google Tasks is terrible.

As I said, I’ve used Outlook for a long time. It’s become very familiar and some of the workflow processes have depended on features exclusive to Outlook. I would need to find something else, as Outlook’s support for Google doesn’t extend much beyond IMAP support for Gmail. If you want to synchronise your Google Calendar with Outlook you can forget it: it’s a clunky business at best, and impossible at worst.

Calendar view in eM Client, showing different colours for shared calendars
Calendar view in eM Client, showing different colours for shared calendars

Someone I follow on Twitter mentioned eM Client which claims to be the best email client for Windows. I gave it a go, trialled it alongside Outlook for just a week and decided that although it lacks a few features that I really like about Outlook this was perfect for my needs. I will write a more complete review of eM Client in a later post.

Something else for tasks

Like Outlook I like that everything is together: email, calendar and contacts. I decided not to use the tasks as support for Google Tasks isn’t great even on Android.

For a week I trialled Wunderlist, which is one of Lifehacker‘s favourite to do apps. I’d tried it before but after a week I still wasn’t convinced: I wanted to use their Windows 7 client but it simply wouldn’t synchronise with the Android app, plus the Android widget was clunky. So I gave up.

Todoist—simple and clean-looking task application
Todoist—simple and clean-looking task application

That’s when I stumbled on Todoist, which I really like. The Android app is clean and simple, the Windows app just works, it synchronises really quickly, and the widget is perfect for my needs—it does what I need, and works the way that I want it to.

I expect that I will stick with Todoist for the near future.

How to move from Outlook to Google

Moving from Exchange to Google was fairly straight forward: mildly complex but not complicated. Here’s what I did:

  1. Synchronise Outlook calendar and contacts data with Google using demo version of Sync2. It allowed me to copy all my data from Exchange to Google Calendar and Contacts with no restrictions.
  2. Add Gmail account to Outlook as an IMAP email account, then copy (or move) emails from Exchange/Outlook account to Gmail.
  3. With everything moved over and essentially backed-up to Google, change MX records in my domain name DNS. Basically, this tells all email to go to my web hosting company (Heart Internet) rather than my Exchange server (hosted by Simply Mail Solutions). The DNS took about 4-6 hours to update.
  4. Create a forward for my email address so that it all gets passed on to Gmail. I did this within my Heart Internet control panel.
  5. Install eM Client and add my Google account. All my data, email, calendar, and contacts is then synchronised with eM Client.

The nervous bit was waiting for the DNS to update, as you need to set the MX (mail) records correctly otherwise it doesn’t work. But as soon as my gareth@garethjmsaunders.co.uk emails started trickling into my Gmail account I knew that everything was fine.

What now?

So far I’ve been using this set up for a couple of weeks and I’m really appreciating having only one place to check email; I’m loving that Jane and I can see each other’s calendars so easily.

I think this is going to work. I wish I’d discovered eM Client and Todoist before now.

I’ve just completed a task 2490 years early

It’s no secret that the default Outlook Tasks application in Windows Mobile 6 isn’t great, and given that I use tasks almost as much as the calendar—perhaps even more so—I’m always on the look-out for a dedicated application that will handle them better.

pTasks

I was therefore delighted when I discovered pTasks, which describes itself as “a replacement for the default Windows Mobile task manager” with a “finger-friendly user interface”.

Perfect!

It costs £2.69 from the Windows Phone app store.

Rather than paying for something that I don’t know if I wanted to keep I went in search of a free, early beta release. I found version 0.5f (the current, paid-for version is 1.5) and gave it a test drive.

An important note is that it requires the .NET 3.5 framework installed first.

Imagine my surprise when I added a new task, “Blog about pTasks”, and reviewed the details:

20110316-pTasks

How efficient am I! I’ve just completed a task nearly 2490 years early.

Updating Outlook Appointments gadget for Outlook 2010

Outlook appointments gadget for Windows 7
Outlook appointments gadget for Windows 7

One of my favourite Windows 7 gadgets is the Outlook Appointments gadget. As gadgets go it’s pretty simple: it shows me  upcoming appointments. From Outlook.

But oddly, only when Outlook is open.

Anyhow, when I upgraded Microsoft Office from 2007 to 2010 a couple of weeks ago I discovered that it no longer worked … it just complained that it didn’t have the correct version of Outlook installed.

The hack

But there is a simple hack:

  1. Make sure that you can view hidden and system files (Control Panel > Folder Options > under View tab select “Show hidden files, folders, or drives”).
  2. Close the Outlook upcoming appointments gadget.
  3. In Windows Explorer navigate to C:\Users\YOURNAME\AppData\Local\Microsoft\Windows Sidebar\Gadgets\OutlookAppointmentsGadget.gadget\en-US\js\” where YOURNAME is the name of your user account.
  4. Open the file “outlook.vbs” with Notepad (or other text editor; personally I wouldn’t use WordPad).
  5. On lines 22 and 42 change the two occurrences of the number “12” to “14”.
  6. Save the file.
  7. Open the Outlook  Appointments gadget again.

Outlook Tasks gadget

The same hack also works for the “Outlook Tasks” gadget.

Update

It looks like someone has released pre-hacked versions of Appointments and Tasks called iOutlook which work with Outlook 2010.  The iOutlook Appointments one now offers 3, 5 or 10 appointments.

Moving to Microsoft Exchange 2007

Computers and devices connected to a server
You say single point-of-failure, I say synchronized data!

Back in July 2009 I upgraded my mobile phone from an O2 Xda Orbit to an O2 Xda Zest. All was well until I tried to synchronize it with two copies of Microsoft Outlook, one at home, the other at work.

It didn’t work.

Windows Mobile 6.1 won’t sync

A quick Web search showed me that I wasn’t alone. It turns out that there was a bug in that version of Windows Mobile 6.1 on my phone. Microsoft had fixed it and rolled out the update to OEMs but it appears that O2 wasn’t going to let it roll any further.

Diagram of Windows Mobile phone synchronizing with 2 PCs
My Windows Mobile 6.1 phone would only synchronize with one PC

So I was stuck with a phone that would synchronize with only one PC. Which was somewhat bothersome as I was rather used to the convenience of my calendar, contacts, tasks and notes being available both at work and at home, as well as on the go on my mobile phone.

I needed to find another solution.

XTND Connect

The first thing I looked for was an alternative to Microsoft ActiveSync (I was using Windows XP at the time) and I discovered XTND Connect.

I wondered if the problem could be bypassed by using an alternative to ActiveSync.

It couldn’t.

That didn’t work either, which made it quite an expensive mistake. The demo version looked promising but was so highly crippled in terms of functionality that I had to buy the full version in order to fully evaluate it. Which rather defeats the purpose of a demo version, in my view.

Sync2

So I looked around at alternative solutions and it appeared to me that there were only two options left:

  1. Synchronize with an online application (e.g. Google Calendar)
  2. Synchronize to a server (e.g. Microsoft Exchange)
  3. Synchronize to a local folder (e.g. USB flash drive)

I explored the Google Calendar and Google Contacts option but (and for me, it’s a deal-breaker, which is one reason I’ve not gone rushing out to buy an Apple iPhone) one the elements of Outlook that I use perhaps more than any other is Tasks. And I couldn’t sync my tasks with Google Calendar.

I assumed that Exchange would be out of my price bracket so focussed on the second option which led me to Sync2 from 4Team.

Not only does Sync2 synchronize your Outlook calendar, contacts, tasks and notes with a folder of your choosing (USB flash drive, local folder, LAN folder, etc.) it will also synchronize with Google Calendar and Contacts.

I discovered that if I synchronized it with a folder in Dropbox at home I could then synchronize it again from the same folder on my PC at work, without having to worry about remembering to pack my USB flash drive.

Three computers using Sync2 synchronizing with a Dropbox folder
Using Sync2 to synchronize using a Dropbox folder

That has been the solution I have been using for the last six months to synchronize my data between home, work and my laptop.

Occasionally I ran into problems with data not synchronizing properly and so had to either

  • Resynchronize a profile (i.e. make it think it was doing it for the first time again.
  • Delete a profile and recreate it from scratch.
  • Reinstall Sync2 completely.

But most of the time it worked pretty well.

Except that it still didn’t address the issue of my mobile phone being out-of-sync for most of the day, between synchronizations at home.

Hosted Microsoft Exchange 2007

So in January I went in search of an affordable, UK-based hosted Microsoft Exchange account.

After some shopping around I eventually selected Simply Mail Solutions (SMS) based in Warrington. What attracted me about their hosted Exchange 2007 account features were (in order):

  • Only £4.99 per month
  • Full support for Windows Mobile including push
  • Full Outlook Web Access (OWA) in Internet Explorer
  • Out of office assistant
  • Free copy of Outlook 2003 or Outlook 2007

With each device connecting directly to the Exchange server I can guarantee that my data is always up-to-date (server outages withstanding).

Various devices connecting to an Exchange Server
Two PCs, a laptop, a mobile phone and Outlook all connecting to the Exchange Server

Another welcome benefit is that I won’t have the problems of duplicated entries that I’ve experienced so many times when synchronizing multiple devices. Here’s a screenshot I took of Outlook and posted to Twitpic last month showing a repeated entry for “Doug Aitken’s Birthday” duplicated 13 times!

Calendar entry (Doug Aitken's Birthday) duplicated 13 times
Calendar entry (Doug Aitken\’s Birthday) duplicated 13 times

I can even resynchronize my mobile phone when I’m out and about using my roaming Web add-on from O2.

Conclusion

So far I’m really pleased with Exchange and with the service offered by Simply Mail Solutions (SMS).

I’ve noticed only one outage from Simply Mail Solutions which lasted only a couple of minutes when connection to the server went down, and one period of particularly slow connectivity … but then it was 01:00 in the morning, they were doing some maintenance on the servers (I discovered via a quick support call) and I should have been in my bed!

There is a balance to be made when using a hosted service like this for such important personal data between:

  1. the reassurance that I have one ‘golden copy’ of data, stored centrally that is accessed by all my devices, and
  2. the potential for it to be a single point of failure: if it goes down completely I can’t synchronize between locations and my data isn’t up-to-date.

But given my previous experience of hours and hours wasted by repeatedly cleaning up corrupted or deleted data through failed synchronizations, and living with the uncertainty that perhaps my work calendar isn’t exactly the same as my home, laptop or mobile phone calendars … I think I’ll stick with Exchange for a while.