Issue with attaching files to an email through VBA

Hi all,
Hoping someone will be able to offer some assistance in getting attachments to an email working, as I seem to be having no luck and after trying a few things I'm just lost. (Am still relatively new to using VBA so apologies in advance.)

I'm having a decent amount of success with the rest of the code after a few hours of almost leaving a laptop shaped hole in a perfectly good window. This is what I have so far:

Please Login or Register  to view this content.

When I run the macro, I am getting the following back:

'Run-time error '440':
The operation has failed.

When I debug, the line in question is .Attachments.Add = srcF



(I appreciate the way of opening the file might not be the best, but macro recorder works well enough so I'm happy with that for now, though wouldn't mind learning a better way)

Forgot to mention, am using Excel 2010.

I posted the same question on reddit here https://www.reddit.com/r/excel/comme...email_via_vba/ but remembered I had much more luck on here in the past after posting and so am trying my luck here again.

Any help would be greatly appreciated!
Thanks, Max

Remove the = sign from that line.

It's always the little things.

Glad we could help, and thanks for the rep.