LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending emails from worksheet Nick Wakeham Excel Discussion (Misc queries) 1 June 28th 06 04:57 PM
Help Sending Emails From Excel mrk0 Excel Discussion (Misc queries) 1 July 6th 05 06:42 PM
Sending Emails according to sheet name Todd Huttenstine[_2_] Excel Programming 1 November 10th 03 04:32 AM
Sending emails from Excel David Robinson[_2_] Excel Programming 1 September 21st 03 08:40 AM


All times are GMT +1. The time now is 01:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"