Send mail from Spreedsheet using vba

Send mail from Spreedsheet using vba

Hello,
 Is it possible to send mails using vba. The examples I found sends the workbook together with the mail but am looking for a solution that sends only the message without the excel sheet.
I tried using the CDO object but kept getting error messages
Any and/or  all assistance would be greatly appreciated