ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sending e-mail it is ok from VBA not from Excel it-self (https://www.excelbanter.com/excel-programming/342991-sending-e-mail-ok-vba-not-excel-self.html)

stabilo

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 ?


All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com