Hiya

I have a VBA that automatically attaches files to a draft email, and it works fine. But when it comes to SharePoint files, it adds %20 into the file names.

Whereas if I attach the SharePoint file manually by going to Attach File > Browse this PC > and I put in the whole URL path to the file, it asks if I want to attach a copy, and I click that, and it adds it without %20 in the filename.

So I'm not sure why it adds %20 when it's via VBA? I've tried removing https: from the string for the path, but it just gets hung up unless I'm using ActiveX, which I'm trying to avoid now since it's gone defunct, so that doesn't work.

Let me know your thoughts!!

Thanks all
James