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.

Please Login or Register  to view this content.
Any help would be much appreciated!

Thanks