Macro to email XL attachments (files are not attached)

Hi there,

I've found a macro on line which will send emails with attachments. The problem I have is that the macro does not pick up the file attachment and I can't work out why. I have tried two macros and seem to have the same problem.

I have attached the macro that I'm attempting to use.

Would someone be able to explain where I'm going wrong?

Thanks in anticipation
Bobbi