Synchronising contacts Outlook 365 with Google v.v.

Status
Not open for further replies.

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?
 
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
-
 
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.
 
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...
 
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?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
O synchronising a computer to an old (IMAP)mail account Using Outlook 2
G Apply Custom Contacts form to all existing Contacts Outlook VBA and Custom Forms 1
G Add Map It button to Custom Contacts Form in Outlook Outlook VBA and Custom Forms 1
B Sync Outlook Public Folders to Contacts Using Outlook 2
Kika Melo How to mark as Junk any message not from Contacts (in Outlook.com) Using Outlook 3
G Outlook 365 My iCloud Outlook doesn’t work after reinstalling Microsoft365 on Windows 10 PC – now I get error message on contacts and calendar Using Outlook 1
T How to Export & Import GMAIL Contacts into Outlook 2021 ? Using Outlook 4
L Applying new form to existing contacts -- MessageClass Outlook VBA and Custom Forms 3
Bardiferous Weird Contacts Behavior - Can't find any in any address book, but they're in there Using Outlook 3
S client lost 3K contacts when office 365 for mac account deleted from company exchange server Using Outlook 5
O How to sync (one way) contacts between two Outlook (exchange) accounts? Using Outlook 0
P How to clear out all contacts in iCloud, so I can use iCloud-based sync program Using Outlook 1
R How to prevent corrupted Notes format in Calendar and Contacts Using Outlook 0
K Outlook 365 After migrating to Outlook 365, some contacts display in emails with prefixes Using Outlook 0
kburrows Outlook or Phone Combining Contacts? Using Outlook 0
Witzker Add a text line at the end of the note field in all selected Contacts Outlook VBA and Custom Forms 7
G Add contacts birthday to calendar Using Outlook 4
R How to force Outlook to use plain text in notes for Contacts? Using Outlook 1
S Cannot print Contacts Using Outlook 7
V Backup Calendar, Contacts, Tasks in an POP3 data file Using Outlook 3
J Outlook 365 Outlook 2016/365 Contacts Lose Info when Favorited to the To-Do Bar Using Outlook 2
D Advanced e-Mail search on from/to contact group only searches for first 20 contacts in group Using Outlook 0
P Outlook calendar and contacts sync problem-outlook disconnects Using Outlook.com accounts in Outlook 2
K Font Sizing in Custom Form Regions for Contacts Outlook VBA and Custom Forms 1
O Outlook - hidden contacts? Using Outlook 2
H Synchronize contacts and calendars across multiple devices Using Outlook 0
S Outlook 2016 Change how Outlook shows me contacts in emails Using Outlook 0
L Favorites for People/Contacts? Using Outlook 1
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
Horsepower Contacts added from iPhone don't show up in Outlook Using Outlook 2
B oContacts.Items.Restrict Misses Some Contacts Outlook VBA and Custom Forms 3
F Moving Contacts to New Profile Using Outlook 0
V Contacts in O365 have changed?? Using Outlook 20
T Outlook 2010 BCM Migration to Standard Contacts BCM (Business Contact Manager) 0
D Outlook Contacts Notes Field Photos to Smartphone Using Outlook 0
G Add to Outlook Contacts - Point to non-default contacts folder Using Outlook 0
D Is a sub folder under contacts necessary to be able to name an Address Book? Using Outlook 1
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 10
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 4
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

Similar threads

Back
Top