Export report data into a web app ? automate it...any idea's

[pooley]

Using Sims

 

Currently we run a report at 9.30 that gives us the Names and Telephone numbers of all absent children for that day, we then copy and paste them into a web based SMS gateway with a std message.

 

I was just wondering if anyone had any idea;s for automating the process of importing the telephone numbers into the sms gateway along with a standardized " your kid isnt in school" message" ??

 

Maybe asking for the impossible/improbable but this is the place to ask

[webman]

Use a VBScript with XMLHttpRequest (to send POST data to your web app form) or create an AutoIt script/program to do a similar thing.

 

It all depends on the format the webpage accepts and via what methods though.