Emailing Options

[dan.cawthorne]

So Heres the Question,

Ive Managed to send my first email by creating a macro and using the
sendobject command and sent my report as an attachment.

though a few things its limited me to, and need to know how to get
round it.

Firstly, I Created a Button to run the Macro,

But i want the emails to be sent daily, Automated with out me having
to press the send button?

Secondly when i run the macro i get a message asking me if i was to
allow outlook to send the email? and i have to select "YES"
i don't want this? can i get rid of this message?

and secondly it says the email is sent from me, i don't want it to be
sent from me, so how do i get around this as well?

i'm open to suggestions?

Dan

 

[Dennis]

First, you can create a command-line in a BAT file that will open Access and
execute the macro of your choice, then close Access. You can add the BAT (now
called a CMD file IIRC) to Windows Scheduler.

As to the FROM field, there is no way to make it from someone else (using
Exchange server and the SendObject methodology) unless you have "On Behalf
of" rights set by the Exchange administrators, and an email account set-up
for the purpose (assuming you DO NOT want it sent FROM any person, but rather
something like "Automailer" or the like).