Is it possible to do a mail merge in Word using a source Excel file hosted in SharePoint?
I have tried using a mapped drive with and without “http” in the address prefix, and it doesn’t appear to work that way for me. I have been able to use OneDrive for Business sync, which makes a local copy. Is there another business user friendly way to do this using Excel files as the data source?
The other alternative I have is to use a Contacts List, and export the data to a temporary Excel file or through a connected Access db. I plan on recommending that as an alternative, as you can also source the Contact List as an Address Book in Outlook.
Thanks!
Jess
