Hi
i want to use excel as source for word mailmerge, and share for multiple users, in SharePoint library or OneDrive.
method 1
set up file dsn pointing to excel file stored in sp library in cloud.
Can a file dsn connect to excel source over http?
method 2
store both files in synced library using Odfb sync tool.
does word use relative path or absolute path? If relative path it will be ok, if not, the data source will not be found on 2 different pcs unless the filepath is identical.
