How to use Senkeys in MS Access 2007 while computer is locked
Posted on 2009-06-29
Hi. I have an Access 2007 form which automatically at certain times sends a report in the body of the e-mail. To have this automated, i have the outlook message displayed and then use SendKeys to Send "Alt S" to automatically send the e-mail. Works fine while my computer is active, but i need this to occur while i'm not there as well. Sendkeys will not work if the computer is locked. I discovered this by coming in to work the next day after leaving it running to find 6 composed outlook messages on my desktop that did not send themselves. Is there a way to use sendkeys while the computer is locked, or if not, is there an alternative method where the e-mails would send themselves while my computer is locked? Thanks.