I have a Word document that I am trying to set up a Mail Merge in. The mail merge is using an excel file to populate the fields. This process works fine when the files are on my desktop. Now that it worked I need to move the files to a shared documents library on our Sharepoint so that others can access it. After I moved the files to Sharepoint I cannot seem to point the Word document to the Excel file it seems because the URL to access it has spaces in it. Here is some info that may help.
Word doc: MailMerge.docx
Excel mail merge source: MailMerge.xlsx
SP shared folder location: https://InternalURL/SP IT Shared Docs/Forms and Templates/MailMerge.xlsx (and .docx)
When I click to select my existing list in Word for the mail merge I am able to get to that folder by pasting the url above. But when I select it I get an error:
Sorry, we couldn't find your file, Was it moved, renamed, or deleted?
(https://InternalURL/SP)
Clearly when it hits the first space it fails. I tried using the same URL above but with replacing the spaces with %20 but that doesn't seem to work either. I cannot change the name of the folders. I also do not want to map a drive to it either, I just need to get the Word document pointed to the Excel document.