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