Remove ms-outlook urls from your Google Contacts

Microsoft Outlook for mobile is one of the best, if not the best mobile mail client out there. However things can get a bit messy if you use the Save Contacts feature on iOS and also have a third party contact sync app keeping iCloud and GMail contacts in sync. I use the awesome Contacts Sync for Google

If you wind up with 100s of contacts having weird urls like ‘ms-outlook://people/’ or notes filled with the text ‘This contact is read-only. To make changes, tap the link above to edit in Outlook.’ then your in a bit of a bind especially if you have a bit of OCD like me.

Have no fear Google Script is here to rescue us. A simple hack and five minutes later you can enjoy a fully cleaned up contacts list without all the Outlook junk.

  function myFunction() {
  var outlookJunkNote = "This contact is read-only. To make changes, tap the link above to edit in Outlook."
  var contacts = ContactsApp.getContacts();
  for (var c = 0; c < contacts.length; c++) {
    var cnt = contacts[c];
    
    //Clean outlook:// urls
    var fields = cnt.getUrls();
    for (var i = 0; i < fields.length; i++) {
      if(fields[i].getLabel() == "Outlook"){
        fields[i].deleteUrlField();
      }
    }
    
    //Clean outlook notes
    var notes = cnt.getNotes();
    if(notes.indexOf(outlookJunkNote) !== -1) {
       var regex = new RegExp(outlookJunkNote, 'g');
       var cleanNotes = notes.replace(regex, '');
       cnt.setNotes(cleanNotes);
    }
  }
}

I have published the script over at Google Script so you can simply save it your account and run it to clean up your Google contacts. Remove Outlook Junk Script

Written on July 21, 2019