Synchronising contacts Outlook 365 with Google v.v.

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Right now I use a complex way of maintaining contacts, using Excel sheets, creating .csv files, importing here and there.
In case of any changes I use a small list of places that should be updated, like in some Excel workbooks and .csv lists, in Outlook contacts, in Google contacts.
Probably I can't do without at least 1/one Excel list: when printing, I can select which data and how to make it fit on paper (margin settings, font type, headers, etc.)

However, I do seek a reliable way to synchronise data between Outlook and Google contacts.

Am using Outlook 365 Exchange

Somewhere I read about a tool named Companionlink. Undoubtedly this is great software, I wonder whether I can manage without it.
The Microsoft support sites are showing solutions of importing .csv files only. Have not found a Wi-Fi solution, at least not when performing a Google Search on:
outlook contacts sync google "wi-fi" OR "wifi"

Any suggestions?
 

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Forgot to add the background of above post...

Importing / exporting using .csv may bring along some additional issues.
For example, within Excel, one needs to remember to change the 'phone number'-cells' properties into 'Text'
Also, at least in my case, I need to add a leading '0' to the phone number, so, 1234567 to become 01234567
I have experienced that this leading '0' is necessary. Google Contacts will strip it anyhow, but without having the '0', after importing into Google Contacts, the number that shows up in the phone book on your smartphone looks fine, but will not connect/dial. When the '0' is added to the phone number in the Excel csv file, then, after importing, the phone number will work fine.
That's all in Excel then.

Also, one needs to verify whether the address fields within Outlook contain commas... in which case one might better switch to the English version of Office.
For example: the Dutch version of Office adds a semicolumn as field separator (although comma has been set...)
and also has a comma in the address fields, like 'Home Address Street' > 'Huisadres, straat' (Home Address = Huisadres, Street=Straat).
When creating a .csv file, Huisadres' and 'straat' end up in separate columns.
Posted a thread on answers.microsoft.com, see below thread. Probably the thread will not be read by anyone within Microsoft though.

All this brings me to seeking a solution that does -not- use the csv import/export method.

-
Outlook - Export/Import contacts - .csv file - list separator issue
-
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You'll definitely need to use a utility to sync with gmail calendar and contacts. Companionlink (my fav) or gsyncit are the two most popular.

Probably I can't do without at least 1/one Excel list: when printing, I can select which data and how to make it fit on paper (margin settings, font type, headers, etc.)
You can do this using mail merge - its easy to filter if you start it in outlook (not in word).

If you want to print from Excel, you can create a filtered table view in Outlook, copy and paste into Excel.
 

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
As always, many thanks Diane. Indeed Companionlink looks really fine. Maintaining addresses has always been a bit of a problem, resulting in keeping various Excel lists up to date and then importing them into Outlook.

It starts with the issue of having in Excel:
- full/complete addresses (i.e. with street names, zip codes, etc.), with 2 'notes' fields, having two different purposes
- having names and phone numbers only (but no addresses, e.g. from club member lists)
- having names and phone and email addresses (e.g. from club member lists, but having mailed with a number of the members)
- having names and email addresses only

Now, image I would manage to get them all in Contacts.
Is there a way to apply some kind of filter and copy those filtered contacts to a different folder within Outlook Contacts.
The contacts in this different folder will be imported into the home handset (Gigaset) using Gigasync software.
Right now I use csv import for this purpose.

Same goes for contacts on the smartphone: I don't need -all- contacts in Google Contacts, I just want to have a set of selected/frequently used contacts on the smartphone. In Outlook contacts I might create a folder, say, SmartphoneContacts and copy the frequently used contacts in there.
How would Companionlink handle that? Would it be possible to sync only a folder within Outlook Contacts?

Sorry for all the questions...
 

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I forgot to ask: Outlook Contacts has first name, last name, full name, etc.

So, there could be
John Doe - with full address/email blah blah
Lady Doe - same

However, when sending an invitation, or something, the address would read like: Mr and Mrs Doe

I am sure you have thought of a solution for that?
 
Thread starter Similar threads Forum Replies Date
O synchronising a computer to an old (IMAP)mail account Using Outlook 2
K Synchronising user calendars in Exchange Server 2010 Exchange Server Administration 1
S Synchronising Outlook on a laptop and desktop Office 2003 and 2007 Using Outlook 1
A Synchronising with ISP instead of deleting downloaded emails Using Outlook 3
B synchronising calendars Using Outlook 1
C Synchronising with Blackberry Using Outlook 1
J Problem synchronising Outlook 2003 calendar and iPod touch Using Outlook 3
L Outlook 2016 Contacts missing in Outlook 365 Using Outlook 1
L icloud contacts sync Using Outlook 4
Fozzie Bear Outlook 2016 Creating a shared local Contacts folder Using Outlook 2
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 3
M Changing the preferred order for "Put this entry in" list for adding new contacts to the Address Book Using Outlook 1
GregS Exporting contacts Using Outlook 1
J can't sync outlook calendar contacts with iphone ipad Using Outlook 4
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 3
egarneau Meeting updates with external contacts (GMail) Using Outlook 1
T Outlook Contacts ... Changing Font Size, Style, Bold, etc. Using Outlook 2
W Remove specific contacts from contact list Outlook VBA and Custom Forms 3
D Can Exchange Admin Center create a pst for users email/contacts/calendar? Exchange Server Administration 0
bhamberg Contacts in a category Outlook VBA and Custom Forms 11
G Outlook 2016 sync contacts directly between phone and computer using outlook 2016 Using Outlook 0
F Default font for notes in contacts Using Outlook 1
F How to create phone number as links in notes of Contacts Using Outlook 2
geoffnoakes Find Contacts with UDFs "in this item" Using Outlook 1
J OLADD.FAE Error When Exporting Contacts Using Outlook 6
T problems with Contacts Using Outlook 8
C Create new Message with shared contacts & BCC'ing recipients Outlook VBA and Custom Forms 0
E GAL Attributes to Contacts Using Outlook 0
L Merge two contacts folders Using Outlook 1
L How do you turn off Outlook contacts "hints" popup Using Outlook 2
N Gathering Calendar Appointments from Calendars that synced as Contacts Exchange Server Administration 1
L Wierd Office 365 Contact unable to edit body of random contacts Using Outlook 5
B How to sync Outlook, iphone and Google calendars and contacts? Using Outlook 4
W Migrating Outlook 365 Contacts & Calendar Using Outlook 2
K Outlook.com is not showing, or finding via search, all my Contacts (People) Using Outlook 0
N Two .pst files on one computer both with contacts? Using Outlook 9
S Import contacts to a shared mailbox Outlook VBA and Custom Forms 2
A Add to Outlook Contacts from email - default view Outlook VBA and Custom Forms 1
B iCloud Option to sync contacts, mail, calendar and tasks Using Outlook 5
T Calender and contacts in trash Using Outlook 1
J what file contains contacts, tasks and appointments stored locally? Using Outlook 1
R How to delete Facebook Contacts folder in Outlook 365 Using Outlook 7
R Using "check for duplicates" for existing contacts Using Outlook 2
B Moving account, contacts & emails to another H/D with MSOutlook Using Outlook 5
M I'm Having problems Moving Contacts to a New List Using Outlook 8
G Autocomplete adds suspicious "@unknown.email" to selected contacts Using Outlook 1
C Import Outlook 2016 contacts into to: field Using Outlook 1
N Need help syncing contacts to iPhone X Using Outlook 8
S Outlook.com birthdays show up 1 day late on iPhone contacts list Using Outlook.com accounts in Outlook 29
Similar threads


















































Top