VBA For Excel to send Email

Hi

I require some VBA code for excel that'll automatically send out an email to the recipients in a certain cell, the subject line being specific to that line. I am using outlook app.

The body of the email should also include a snippet of the file.

I've managed to create some of the code, however it doesn't work as I'd like, I think it would be a simple job to complete. My current code, only includes the attachment and nothing within the body and I can't get it to send automatically, it creates the emails, however I then have to select send on each open window of outlook.

I'm happy to share the code I currently have to be adapted or you can create new code.

Thanks