Perform action on receipt of an email

Spazdarn

Hi I get an email into my outlook every day.

I was wondering if anyone had a vbscript or a batch file that could automate an action on receipt of this email?

tenifan

ToiletFusion wrote: »

Hi I get an email into my outlook every day.

I was wondering if anyone had a vbscript or a batch file that could automate an action on receipt of this email?

Google is your friend..
Basically, write the code in VBA, and create rules in outlook.
http://support2.microsoft.com/kb/306108

solomafioso

Or you could create rules?

http://office.microsoft.com/en-ie/outlook-help/create-a-rule-HP005242897.aspx

Spazdarn

Thanks for the input, but it's not specifically just rules, the vb script would require the ability to automate the movement the mouse and click outside of the email client.

tenifan

ToiletFusion wrote: »

Thanks for the input, but it's not specifically just rules, the vb script would require the ability to automate the movement the mouse and click outside of the email client.

I can see very few instances where any program would want to take control of the mouse.

Anyway, vba won't do that.

(fyi, the more info you give, the more likely you are to get a helpful response)

Spazdarn

I'm behind a firewall at work so I'm unable to get at these mouse controller programs.

I'm trying to automate specific tasks, like check email, on receipt of email, tick a box on a jobsheet, copying and pasting in a comment etc.

Or something as simple as clocking in to my computer and pressing a button, I got pretty far with this on vb but the last button is a hidden button so I can't reference it to click it.

tenifan

ToiletFusion wrote: »

I'm behind a firewall at work so I'm unable to get at these mouse controller programs.

I'm trying to automate specific tasks, like check email, on receipt of email, tick a box on a jobsheet, copying and pasting in a comment etc.

Or something as simple as clocking in to my computer and pressing a button, I got pretty far with this on vb but the last button is a hidden button so I can't reference it to click it.

For the "tick a box on a jobsheet".. this can be done through vba assuming the jobsheet is an excel spreadsheet. Similarly copying and pasting comments can be done through VBA into word or excel.

As for clocking in to your computer or control the mouse, you won't be able to do this through VBA and the outlook rules won't allow you to use VB or other scripts.

Spazdarn

tenifan wrote: »

For the "tick a box on a jobsheet".. this can be done through vba assuming the jobsheet is an excel spreadsheet. Similarly copying and pasting comments can be done through VBA into word or excel.

As for clocking in to your computer or control the mouse, you won't be able to do this through VBA and the outlook rules won't allow you to use VB or other scripts.

The tick the box is through a web based interface, so I'm not sure if I could get it that accurate...

ressem

If you're looking for hints on navigating through the site using a script, you might want to try the Selenium plugin for Firefox, and the Selenium IDE.

You can navigate through the website using a browser with the mouse and it'll create a script that you can replay, or investigate for the method that it's using to select the webform's buttons etc.

ED E

ToiletFusion wrote: »

The tick the box is through a web based interface, so I'm not sure if I could get it that accurate...

If the button on the page is just a HTTP POST/GET you can do that from a batch file by just opening explorer.exe with the correct URL.