Recently my friend had a requirement of sending a mail from Excel, so i helped him to do it with a simple code. This code works if Microsoft Outlook is installed in the machine
'mail using the outlook URL format
URL = "mailto:abc@gmail.com?subject=Work Request Recieved.&body=You got some work to do"
' Execute the URL (start the email client)
ShellExecute 0&, vbNullString, URL, vbNullString, vbNullString, vbNormalFocus
' Wait five seconds(for the compose window to open) before sending keystrokes
Application.Wait (Now + TimeValue("0:00:05"))
Application.SendKeys "%s"
