ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SendMail without open Outlook (https://www.excelbanter.com/excel-programming/379044-re-sendmail-without-open-outlook.html)

Ron de Bruin

SendMail without open Outlook
 
Hi Kent

There is a option in Toolsoptions..mail setup in Outlook

--

Regards Ron de Bruin
http://www.rondebruin.nl



"Kent" wrote in message
...
I use the method ActiveWorkbook.SendMail
Until now it had works fine with only Excel open (had just answered yes to
the warning message which appears). It had been with Windows 2000 and
Excel XP

After upgrading to Windows XP and Excel 2003 (yes downgrading!) the mail
is
not send before Outlook is open, and it is not always the users has
Outlook
open, and therefore will the mail not be send any longer.

I like the method to send without open Outlook as it has been done before
the upgrading - can anybody give an explanation of how the difference and
what to do ?

Regards
Kent.




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

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