Auto-sending an e-mail report using task manager

J

jonefer

My manager wants to automatically send an internal e-mail "Text" format of
either table or query results from an Access databse The generating PC is
Windows 2000.

I tried it using Task manager (Windows Scheduler)
I have an "auto_exec" macro that runs when an mdb file is opened
it uses SendObject

but I am prompted for the Exchange Server profile. Is there anyway to
by-pass this?
....all the parameters for the SendObject command are correct, because the
e-mail generates just fine if the Exchange Server profile is answered.

He wants the e-mail to be auto-generated unattended.

What am I missing, to make this work properly?
 
Top