Incorporating sending email once data dump macro is activated

Good day everyone. I've been looking at Ron De Bruin's guide on how to make excel send an email through outlook (https://www.rondebruin.nl/win/s1/outlook/bmail2.htm) but I can't make it work with the current worksheet's macro. My goal here is once the auditor completes the form and clicks "Upload", it will trigger the upload macro and save the data in the Form tab to the Data tab (which works), and I would also like that macro to send first in Outlook the contents of the Form tab before the form gets reset/cleared as part of the upload macro.

Thanks in advance!

(please don't mind the excel errors in the Form tab, Upload macro should still work even with those)

hello dangelor - would that be just pasted after the sub(upload) and would work once the upload macro's used?

ran into two errors:
1. duplicate declaration - there was already a <Dim rng As Range> declaration at the top part, so I just removed the 2nd one and it took care of that. however, I then got the error
2. expected end sub - it stops at "End Function" on the upload part of the macro

how can that be fixed?

problem solved, thank you so much!