Remove the error and clean my code to send mail automatically from excel

I dont think you can do that.
If you want to send an email without Outlook being opened, you will need to use the SMTP object or the CDO object.