Allow mailmerge using SharePoint (and/orOneDrive) based lists and document
Allow Office 365 Word/Excel mailmerge functionality when the files are stored on SharePoint (Online or on-premises).
As per: https://answers.microsoft.com/en-us/msoffice/forum/msofficesharepoint-msowinother-msoversion_other/word-mail-merge-with-excel-document-in-a/81cd913e-9a57-4bf8-99ca-a766b57b2531
The Office client people I know seem to think this is a SharePoint Online limitation, while the SharePoint people seem to think the Office client team need to sort this.
Caty Hespel commented
I read a suggestion by a microsoft moderator that syncing the library would solve the problem, but this is not an option in my case as this library contains thousands of sensitive personel files that should not be stored on local computers.
Mail merge da Share point, e' una funzione importante per non dover sempre fare il download in locale dei file per il mail merge
This should be a great progress in this COVID time ...
I'm so frustrated that this cannot be done. At my workplace we need to use the Sharepoint option for the excel-file but it now seems that we cannot create a mail merge ...
Ben W commented
Carlos Morales Lemus commented
Please enable functionality "Allow mailmerge using SharePoint (and/orOneDrive) based lists and document".
Je souhaiterais pouvoir réaliser des publipostages entre des tableaux excel et word.
unfortunatly this is still an issue in Office365. When synching the doc lib it work refering to the XLS on the machine... however no one else can open then the word doc... We have teams who need to Share as that's the whole point :-)
I have a similar issue. I agree that OneDrive sync works but it only works for one individual. I have a mail merge Word file with Excel dataset that my team use. It was working fine when our data was on the local server but since we moved to SharePoint, the links stopped working. I updated links for my machine's OneDrive synced copy now and it works for me but my team can't use it as their OneDrive synced copies have different address of the Excel dataset.
Rob Short commented
We use the OneDrive sync client to sync the doc lib containing the Excel file sync'ed locally. Then we can browse to the file and use it for merging. Agreed it would be useful to be able to do it natively without using the sync client though but by no means is this not doable.
I'm not sure which team is responsible for the Excel/Access ODBC connector - could be Windows 10 team, could be Office team
I don't think this is an SharePoint document library issue as such as there are obviously functions available to allow Office to open documents from SharePoint. However, mail merge appears to use a Windows function to interface in with the data source - guessing maybe ODBC as that's used to interface databases with mail merge. So I'm guessing that it's the Excel/Access ODBC connector that can't handle HTTP based documents: https://i.imgur.com/jDp6MO7.png
I am totally and utterly flabbergasted that Word/Office cannot use mail merge when the source Excel document is stored in SharePoint. When I user asked me about this, I thought "Of course, it'll work" but when I try it, you a) can't browse SharePoint and b) if you have a network location mapped (WebDAV), you can't use that either.
Office 365 is Microsoft's cash cow these days but there are still so many features that don't work.
Come on Microsoft - you are in control of Office, Office 365 and the operating system. This is such a basic requirement.
Jeanine E. Leary commented
This would be such a great addition, we use SharePoint list for new hire onboarding and I create a "Welcome Letter" via Mail Merge. As of now, I have to export the list as a CSV file and save as and then run my merge. Too many steps. Want to be able to finish my FLOW to do this automatically!
Are there any plans to do this?
Mergim Esati commented
Wow, I can't believe this hasn't been done yet.