 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
zoomer
Joined: 12 Apr 2013 Posts: 1 Country: Canada |
|
Send Keys VBS |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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
|
|
Sun Apr 14, 2013 8:40 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|