Launch Email from VBA

[soood]

Hi all, I am tring to launch an email window with the recipient filled in and the subject filled in from Excel. I have the following codeL

ActiveWorkbook.SendMail Recipients:="[EMAIL="xxxx@xxxxx.com"]xxxx@xxxxx.com[/EMAIL]", Subject:="Subject " & Format(Date, "dd/mmm/yy")

The problem is that the code puts the mail in my outbox when I only want it to launch the email window...Any ideas?


Thanks!

 

[John_w]

See http://www.mrexcel.com/forum/showthread.php?p=2291864#post2291864