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