Hi - I got the trial version of 24x7 to see if it will work for my purposes. I want to be able to get the desktop to wake up at a daily scheduled time, log me in, execute a VBscript which calls Excel, Outlook, sends emails, etc.
The first issue I ran into is the SendKeys command. It prepares an Outlook form and it has to be sent but I have to press Alt-S keys to send it due to the Outlook security set up.
The following command in VBS does not go through:
Wshell.SendKeys "%S"
It brings up the Outlook and prepares the email but just sits there and doesn't hit the buttons to send.
Am I missing something in the process? I searched the forum with send keys and outlook but could not find anything.
thanks

Fri Apr 12, 2013 2:40 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6573

Use of SendKeys and similar interactive UI methods are a bad idea for automating non-interactive unattended processes, it's a non-starter. Please consider using programmatic methods available in MS Office applications to automate their activities. Also please be aware that Ms Outlook is specifically designed for security reasons to block automated email sending Use email functions built into 24x7 to send emails and files. When designing automation jobs, use proper methods that do not require an interactive user to be logged in. This is one of the basic things