ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sendmail not working when computer is locked (https://www.excelbanter.com/excel-programming/338802-sendmail-not-working-when-computer-locked.html)

[email protected]

Sendmail not working when computer is locked
 
Hi,

I'm trying to make a procedure which will automatically email the
active workbook using the following code.

ActiveWorkbook.SendMail Recipients:=oReceiver, Subject:=oSubject

Application.Wait (Now + TimeValue("0:00:03"))
Application.SendKeys "%1"


The procedure works perfectly except when the computer is locked (using
Ctrl+alt+del). In this case the email is created but not sent.

I am using Lotus Notes

Thanks in advance for any help.



All times are GMT +1. The time now is 08:37 AM.

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