Auto Emailing Macro needs fix

Hi excel masters,

I am working on a macro that is aimed to send emails to people listed on the spreadsheet however the code I am using seems to be bit annoying.

It gives me a pop up box that asks my permission before it sends an email out. any help in getting this fixed is of great help. (looks like this is due to late binding method)

Also, would like to add a msg box that would tell the user that emailing activity is complete and now the file is safe to close. once the user clicks ok then the file should close automatically.

I have attached the file for reference.

Looking forward for your help...

Regards,
Kiran