Al Smith
Dec 5th, 1999, 03:43 AM
Hi,
I use VB to download data from the company's computer (BaaN/Unix) using OLE, perform some analysis on the data then create Excel spreadsheets with the data. These are simple .exe programs that kick off at night through a task scheduler (WinNT). These spreadsheets are then sent to various department managers via Novell's GroupWise. I have been using "Sendkeys" to do this. This has worked OK for the 12 or so departments.
I now have to perform some analysis for 97 remote warehouses across the country and e-mail the Excel spreadsheets to them.
Now, finally, my question(s).
Is there a way of doing this without "Sendkeys"?
Is there perhaps some software already available that will do this?
I've checked the Novell sites and have found nothing.
Al.
ps. If I don't get any responses, I'll understand.
I use VB to download data from the company's computer (BaaN/Unix) using OLE, perform some analysis on the data then create Excel spreadsheets with the data. These are simple .exe programs that kick off at night through a task scheduler (WinNT). These spreadsheets are then sent to various department managers via Novell's GroupWise. I have been using "Sendkeys" to do this. This has worked OK for the 12 or so departments.
I now have to perform some analysis for 97 remote warehouses across the country and e-mail the Excel spreadsheets to them.
Now, finally, my question(s).
Is there a way of doing this without "Sendkeys"?
Is there perhaps some software already available that will do this?
I've checked the Novell sites and have found nothing.
Al.
ps. If I don't get any responses, I'll understand.