Unfortunately yes, and even tried incorporating the Sync feature, but the issue is that there are files in many various areas on SharePoint, which get updated monthly by different teams (things like fact sheets, etc), so having local copies would mean having to download them all every month, and there's a lot of files... whereas currently, I just have notifications set up on SharePoint to notify me when changes have been made, and then I only need to update the strings (which the VBA grabs from a txt file), which is a lot quicker.

So I'm at a loss really! I might have to settle for the %20 ! I'm just not sure why if I do it manually through Outlook and 'attach as copy' it doesn't include the %20... oh well!