Launch Email from VBA

soood

Board Regular
Joined
Feb 25, 2009
Messages
81
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


Code:
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!
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,950
Messages
5,508,321
Members
408,678
Latest member
ripperbolt

This Week's Hot Topics

Top