Starting MS Outlook via script

[Jasmine]

I have a VB Script that's scheduled to trigger via a 3rd party scheduler.
This script calls a Access Module that runs a customed Report every 2 weeks.

So far I've been happy with this.

The problem is my computer needs to have Outlook loaded to run, otherwise
it will just wait asking to load Outlook.

Is there a way I can start outlook via a script ( I have an Exchange based
company Outlook , which requires login credentials )
or send the file out by some kind of SMTP mechanism?

I'll be happy for any other type of suggestions.


Jasmine

 

[David H]

See below...

I have a VB Script that's scheduled to trigger via a 3rd party scheduler.
This script calls a Access Module that runs a customed Report every 2 weeks.

So far I've been happy with this.

The problem is my computer needs to have Outlook loaded to run, otherwise
it will just wait asking to load Outlook.

What do you mean by 'LOAD'? Are you referring to Outlook being installed or
not installed on the PC or are you referring to Outlook being installed on
your PC and actually open and RUNNING?

Is there a way I can start outlook via a script ( I have an Exchange based
company Outlook , which requires login credentials )
or send the file out by some kind of SMTP mechanism?

You can certainly start Outlook using a script, however you will not be able
to pass through a user name or password for security reasons. If its even
possible, you'd have to have the user name and password embedded in the
script which would violate your organizations security policies.

That being said, WHY does the file need to be emailed? The general trend is
NOT to send files, but rather to save the file in a location that everyone
can access and then send out an email notification.