Hiya
I've been struggling to come up with a code that works for downloading the file temporarily (with the file path called from a string), renaming it to remove %20 and then attaching it to the email, then deleting the temp file... This is a bit of a side-gig for me so I'm not a pro like you by any means.
What you're suggesting sounds perfect, I'm just not sure how to achieve it sorry. If you have any time to suggest some code, I'd really appreciate it. No worries if not!
Thanks
James