How to copy list of names/adresses from SharePoint list to Outlook?

Deleted
Not applicable

I have a SharePoint list with name and email address for a number of contacts. Can I export all (or selected) names/address to Outlook - or do I have to do it one line at a time?

2 Replies

Use the ribbon and click connect to Outlook. It will sync the list so that if a new item is created in Outlook it will be in SharePoint and if created in SharePoint will show in Outlook.

 

Bear in mind that the Connect to Outlook option does not work for all the lists and all the browsers. This option is only available in the classic view of a SPO list. As an alternative, what you can try is to create a Contact List in SPO and copy the relevant data (using quick edit option or Export to Excel) from your list to the Contact List. Then, use the Connect To Outlook option advised