Outlook Automation

  • Thread starter Thread starter humberto
  • Start date Start date
H

humberto

Hi. I wrote VBA code in order to send an email via Outlook
using automation. Everything works fine when someone is
logged onto the computer. I have a Windows 2000 Adv Server
with an Access FE/ BE setup.
I setup the Windows Task Scheduler to open a batch file
which in turn opens the .mdb file that automatically sends
the email. Like I said, everything works fine if the
computer is logged on. But when it logs off, the emails
are not sent via automation. The VBA code reaches
the .send command, and does not process it.
Why is this? Do I have to configure something in Outlook
or Windows that I do not know about.

Romulo
 
humberto said:
Hi. I wrote VBA code in order to send an email via Outlook
using automation. Everything works fine when someone is
logged onto the computer. I have a Windows 2000 Adv Server
with an Access FE/ BE setup.
I setup the Windows Task Scheduler to open a batch file
which in turn opens the .mdb file that automatically sends
the email. Like I said, everything works fine if the
computer is logged on. But when it logs off, the emails
are not sent via automation. The VBA code reaches
the .send command, and does not process it.
Why is this? Do I have to configure something in Outlook
or Windows that I do not know about.

When you're not logged on there is no Email profile to use so Outlook cannot do
anything. You can set the Scheduled Task to use a specific User Account when it
runs.
 
Back
Top