Email Problem

[mboe]

I have a database setup to run a bunch of reports and print them at a certain time using scheduler. Works great. We wanted to switch to emailing the reports which also worked fine using a sendobject macro.

The problem is that unless I have outlook (running with an exchange server in this case) open the program can't send email. I have to use the scheduler on the 2000 server because of where the data is. It tries to open outlook but it stops at the choose profile but it enters the company name in.

Is there a way to enable mail sending without outlook open? Or is there a way to default the outlook info that would allow it to open and send correctly.

I am using Access 2000 and it is suppose to a have good integration with outlook but I can't figure it out.

Any help would be appreciated. Thanks!

 

[OSCSLeo]

You can use the following code to open outlook prior to executing your email

Dim stAppName As String
stAppName = "C:\Program Files\Microsoft Office97\Office\Outlook.EXE"
Call Shell(stAppName, 1)

HTH