vba - Error in sending mail through outlook using VB

Question

I am verymuch new to VB. I am getting error no 287 (Application defined or object defined error)whil sending email from excel (outlook 2010). I have set Tool->option

Advance thanks for your kind help

Answer 1

In order to send an email message from excel via outlook, you would have to set an refrence to outlook in Excel VBA

Tools -> Refrences -> "Microsoft Outlook 12.0 Object Library"

Then you have to use a similar code written in excel vba to send mail using outlook

Mail worksheet in the body of the mail