Hi,
My first post so I hope that this makes sense!
I am trying to add multiple attachments from within the same folder to an email.
The names of the attachments change each week that I run the macro and there I need to link to a fixed cell in my Excel document (which changes weekly). I would like to add attachments from cell [B10] & [B11].
I have posted my attempt at code below. Unfortunately, I am currently getting a Run Time Error 440: This operation failed.
Any help would be much appreciated!
Thanks
Bookmarks