Connecting to sharepoint list from excel 2016 for mac

Another possibility is that the Sharepoint settings have changed - are you the Sharepoint Administrator, if not contact Admin and ask them whether settings have changed.

In the Data ribbon, click the Get Data dropdown at the very left of the ribbon and select Data Source Settings.

Make sure to select Microsoft account and enter your Office 365 credentials.

You need a query directly to a SharePoint list, so you need to start it with Data ribbon Get Data From Online Services From SharePoint Online List.

I added some more info in my post about a SharePoint Online list connection.

Could you try to connect to the SharePoint site with and see if it helps.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel or ask your own question.

And here, I am clicking on the Mail Merge Toolkit option Use SharePoint list as Data Source.

In the dialogue window here, I need to type the address of my corporate SharePoint site, my login and password.

In the To field, the e-mail address field should be selected.

But I can personalize Subject line as well: my recipients company name can be selected from the SharePoint list.

The name of that file is unique too: I am selecting the data source field to be used as the Attachment name.

By the way, in this window, I can import message text from a RTF template-file, or even save my text as the template for further mailings: right-click mouse in an empty place in the edit field to call the context menu options.

When I open my Word document next time, the Mail Merge system reminds me to connect to my previously used data source.

And once I confirm the connection Mail Merge Toolkit is checking for the updates of the list and loading the most recent version as my recipient base.

And the tool will load the most recent and actual version of your contact base from your SharePoint Server, just with a single click.

If they are please terminate these processes, or simply log off and log on.

Connecting To Sharepoint List From Excel 2016 For Mac