Mail to be sent from Excel with info from specified columns

[chris1979]

Hi Team
I would like to send a mail from excel with the info from
- specified columns
- Specific email body

Please see screenshot
- SDA email - that should be To
- TL Email - That should be in CC
- Reason and INC/WO should be in subject with line "Returned Ticket......
- Email body - "Your ticket has been returned"

I tried some codes but getting a lot of errors. Please assist

Regards
CT

 

[chris1979]

Any assistance