.
One thing that will assist in troubleshooting any macro is to comment out (or delete entirely) the line "On Error Resume Next".

I did not review the email code for accuracy but I am presuming if you got it from Ron deBruin's site it is good. He does have an
example of making a copy of the existing workbook and attaching it to the email for sending.