View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jeffstryer@hotmail.com is offline
external usenet poster
 
Posts: 5
Default Sending emails with VBA is somehow getting stopped - help appreciated...

Hello,

I am using the following code fragment to launch email

URL = "mailto:" & Email & "?subject=" & Subj & "&body=" & Msg
ActiveWorkbook.FollowHyperlink (URL)
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%s"

The outlook email message is popped up and populated correctly but
when the
sendkeys instruction is hit, there is a beep and the message does not
get sent.

I do not have norton installed and I diabled my pop-up blocker. not
sure what else
could be happening

This was working fine some time back using outlook express. the only
thing that
changed that I recall is that i'm now using outlook.

Any help greatly appreciated

Jeff Stryer