View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stabilo stabilo is offline
external usenet poster
 
Posts: 14
Default sending e-mail it is ok from VBA not from Excel it-self

Runining the following code direclty from the Visubal Basic Editor :

sub test()
ActiveWorkbook.sendmail "receipient" , it is ok
end sub

(after this I'm asked if I want to send the e-mail or not)

when I run it from Excel it-self, nothing happpen (in fact the hourglass
comes but ande stay there, and I'm never asked if I want to send the e-mail
or not.

Any idea ?