synchronize outlook contacts

%3CLINGO-SUB%20id%3D%22lingo-sub-738284%22%20slang%3D%22en-US%22%3Esynchronize%20outlook%20contacts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738284%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20requirement%20is%20to%20automatically%20keep%20the%20contacts%20in%20my%20customer%20database%2C%20which%20are%20in%20an%20excel%2020019%20table%2C%20synchronized%20with%20the%20Contact%20book%20of%20the%20Outlook%202019%20account%3CBR%20%2F%3EAt%20the%20moment%2C%20through%20an%20excel%20macro%20I%20can%20automatically%20create%20the%20.CSV%20file%20to%20be%20imported%20in%20outlook%20but%20I'm%20looking%20for%20a%20Macro%2C%20a%20software%20or%20other%20solution%20suggested%20by%20you%20to%20automate%20this%20procedure%3CBR%20%2F%3Ehow%20can%20I%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738284%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExchange%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738356%22%20slang%3D%22en-US%22%3ERe%3A%20synchronize%20outlook%20contacts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738356%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F371170%22%20target%3D%22_blank%22%3E%40salvatore75%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20you%20use%20Office%20365%3F%20I%20would%20simply%20get%20a%20Business%20Premium%20licence%20which%20includes%20Exchange%2C%20an%20evergreen%20version%20of%20Office%20(including%20Outlook)%20and%20the%20Outlook%20Customer%20Manager%20for%20unifying%20and%20managing%20contacts%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fen-GB%2Fbusiness%2Foutlook-customer-relationship-manager%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fproducts.office.com%2Fen-GB%2Fbusiness%2Foutlook-customer-relationship-manager%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20not%20recommend%20keeping%20these%20in%20an%20excel%20table.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-741533%22%20slang%3D%22en-US%22%3ERe%3A%20synchronize%20outlook%20contacts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741533%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDear%20Christopher%20Hoard%3CBR%20%2F%3EMine%20is%20an%20office%20365%20business%20essential%20account%20exchange.%20so%20I%20do%20not%20have%20a%20Customer%20Manager%20outlook%3CBR%20%2F%3EI%20need%20to%20automatically%20synchronize%20the%20contacts%20between%20excel%20and%20outlook%20without%20always%20having%20to%20do%20the%20import%20procedure%2C%20because%20my%20customer%20management%20is%20in%20excel%20and%20having%20that%20data%20in%20outlook%20thanks%20to%20the%20exchange%20account%20my%20smar5tphone%20tells%20me%20who%20it%20is%20when%20I%20get%20a%20call%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

My requirement is to automatically keep the contacts in my customer database, which are in an excel 20019 table, synchronized with the Contact book of the Outlook 2019 account
At the moment, through an excel macro I can automatically create the .CSV file to be imported in outlook but I'm looking for a Macro, a software or other solution suggested by you to automate this procedure
how can I do?

2 Replies
Highlighted
Hi @salvatore75

Do you use Office 365? I would simply get a Business Premium licence which includes Exchange, an evergreen version of Office (including Outlook) and the Outlook Customer Manager for unifying and managing contacts

https://products.office.com/en-GB/business/outlook-customer-relationship-manager

I would not recommend keeping these in an excel table.

Best, Chris
Highlighted

@Christopher Hoard 

Dear Christopher Hoard
Mine is an office 365 business essential account exchange. so I do not have a Customer Manager outlook
I need to automatically synchronize the contacts between excel and outlook without always having to do the import procedure, because my customer management is in excel and having that data in outlook thanks to the exchange account my smar5tphone tells me who it is when I get a call