PC Review


Reply
Thread Tools Rate Thread

ActiveWorkbook.SendMail and IE - odd problem

 
 
drumstruck
Guest
Posts: n/a
 
      12th Mar 2008
I added a button to an existing Excel sheet so the user can email the sheet
to me. It works fine if run from Excel.
However, the user accesses the sheet from an ASP menu, delivered via
Internet Explorer. When the user clicks the button, the
ActiveWorkbook.SendMail command works fine. But any VB command after the
SendMail fails.

For example,
Sub crct()
ActiveWorkbook.SendMail _
Recipients:="(E-Mail Removed), (E-Mail Removed)", _
Subject:="correction requested"

Range("d5:e7").ClearContents
Range("d2:d3").ClearContents
End Sub

The Range command gives me "Method Range of object _Global failed".
I get some type of error for ANY command executed after the SendMail
command, but only if run via IE.

Any ideas?
Thanks!


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveWorkbook.SendMail Recipients jknapp1005 Microsoft Excel Programming 2 4th May 2009 10:28 PM
ActiveWorkbook.SendMail not working Craig Microsoft Excel Programming 1 7th Mar 2006 03:50 AM
Alert message during Activeworkbook.sendmail N10 Microsoft Excel Programming 3 2nd Apr 2005 01:32 PM
ActiveWorkbook.SendMail =?Utf-8?B?U2FuZHk=?= Microsoft Excel Programming 2 15th Mar 2005 07:17 AM
Activeworkbook.sendmail Jamie Microsoft Excel Programming 2 2nd Oct 2003 01:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:07 PM.