Send Emails when PC is locked

Hi all.

I have inherited a macro that gathers information and then sends an email if certain criteria are met with Outlook desktop. The system have been working flawlessly for sometime. We have noticed that the macro stops only when our windows 10 PC locks or goes to sleep. I did some researched and it appear the sendkeys won't allow email to be sent when the PC is locked.

I read somewhere that I could use windows scheduler to create a process to send at certain intervals. Because of our group policys on our system, Scheduler is disabled. Besides, we need the macro to send emails immediately.

Is there another method that I can use to get emails to be send whether or not the PC is locked? Below is the working code stored in an excel class module.

Please Login or Register  to view this content.

Sorry, that last piece of code is being used for something else. Still the sub CreateEmail, generates the email but won't send while the PC is locked.

Try commenting out the .Display line. If that doesn't work I will try to set up a test that is like what you are doing.

I am so sorry.. I inherited this and this is not my strongest field at all. It looks like I was interpreting the code wrong. Below is the code that I missed. Looks like it was using both the CreateEmail and SendEmail sub. Perhaps this method was used to get around the outlook prompts. We decided to not use outlook at all and just use CDO method. I tested the CDO and that work on a test. Can you by chance help me incorporate the CDO method for this instead of using Outlook and perhaps we will be able to send while the system is locked?

Please Login or Register  to view this content.

Thank you... It won't let me post CDO code because it said I could post anything with links which the code contains. Perhaps I can send another way?

Hi the caseNo is a numeric value and we are using in-house server.

Thanks

That is the code I need help with incorporating into my existing code and didn't know how to do so. I tested it and it work to send in a separate workbook, but don't know how to replace it with mine without messing up things. Thanks

The problem seems to be with windows 10.
I have tried this at work and I keep getting errors no matter what I try.

When the pc locks or sleep mode, it won't run.

Read this for deeper insight.

https://www.thespreadsheetguru.com/b...a-macros-daily


https://support.microsoft.com/en-us/...tion-of-office

I am so excited and grateful to you guys. The solution below worked. Thank you so much.

Originally Posted by CK76

Did it work as is when you use his code? Without incorporating into your code. You should check that before you implement to existing code.

If it does it would be something like... Note that it's independent from your EMail class module.

Please Login or Register  to view this content.