I got this from http://www.mvps.org/word/FAQs/InterDev/SendMail.htm this also has alternate verisons of the same type of program too.
First go to Tools>Refrences to set(check off) the Outlook refrence in the visual basic editor or this wont work:
Sub Macro1()
Dim bStarted As Boolean
Dim...
Hi,
I have an HTML form that when filled out will run a DOS like program and send keys to it to automate a few processes. The problem is that somewhere in the middle sendkeys stops. I ran the program using notepad and sendkeys completes but using this other application it stops at the same...
Is there a way to do this in vbscript? I would like to have a button on an html document that would bring up the person's ms outlook contacts and then populate a text box on the document with their contact's email. This would be on an intranet website by the by.
Thanks for your time!
Jason
thanks dilettante! thats where my problem was! I read about using quotes for the filepath to be able to include spaces but when I tried it, it failed. but it didn't dawn on me about the escape characters.
Thanks!
Jason
Hi,
This may not be the correct place to ask but I don't know where else to post this...I am tring to figure out why excel is not able to find a file with spaces when it is placed on an intranet server. I converted the filename/path to the MS DOS format and it runs fine locally (from the C:\)...
Hello again,
It works on the computer at work! But only when the .vbs file is saved locally (c:\wait.vbs). Is there a way use this file in a server folder like \\Server\wait.vbs or file:///\\Server\wait.vbs so I can edit the file without having to update everyones computer? I tried these but...
jonscott8,
I used your second method with the 'wshshell.run "cscript.exe C:\yourscript.vbs",0,True' and it works great on my home computer! On Monday comes the moment of truth when I try it at work with that computer that gave me problems with my original code.
I wonder why the...
I don't know anything about API, is there any tutorial sites out there that I could learn from? I looked but didn't come up with anything.
I don't have access to the companys SQL because I'm not an IS guy. I'm just able to put this file out there and let everyone access it through the server...
This file will not be on the WWW (like http://). I plan on having it on an intranet server like file://Server/form.htm or if necessary have my co-workers save it locally, like file:///c:\form.htm. I never heard of HTA, Ill check it out.
Thanks again!
Jason
Thanks for the information, I had a feeling that the processor didn't like that I had those wait loops in there like that. I'm gonna try this with my script!
many thanks!
Jason
Yes, notepad does startup and sendkeys works and types the username & password, but it hangs-up after that and doesn't execute the last sendkeys statement.
The only loop I am using is in the wait() function, and it works the first two times it is called but I'm not sure what goes wrong...
Hi, I am tring to automate and streamline some processes at my job so I created an HTML document that uses javascript to compile information from a form and pass it to a vbscript function to execute. I use notepad as a testing program to receive the sent keys. My program works like a champ on...
Hi, I am tring to streamline some processes at my job, and I am using sendkeys, activateapp etc. Ok in my office we all use WIN NT and the latest version of IE. I have developed this program that will work great on my computer at work and at home (i have win 2000 at home) but i gave it to one...
Great on the subject line huh?
Ok, I have a form that will add extra fields based on how many times a user clicks on a link. Then when the user clicks on the execute button it should pass the information entered to notepad. I would like this to work for as many extra fields as the user...
Perfect! I didn't realize that when it was running, it was on my local machine and when I started running it with the errors it was saved on my folder on in intranet! All I had to do was enable ActiveX on my IE intranet security!!!
Thanks !!!!! (:
Hi, I am tring to automate some tasks using vbscript at my job. Below is a simple version of the code I have so far.
The example code below is using notepad as a test application; it is to run and receive data from vbscript's sendkeys. The data that the vbscript function is sending is...
Hello,
I have several html documents with that contain instructions on running reports for many different clients. I am going to use scriptlets so when a contact's fax number or whatever changes all the other documents will change when I update one .txt file.
I would like to have it where the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.