Email Query Results

[eddie_keating]

Hi -

I am trying to set-up an automatic (i.e. no human action required) 'alert' system which will send an email (to a group of people) stating that an action is now overdue.



At the moment I am using SendObject to email the relevant query but I am having some troubles...

Firstly, I'd like the SendObject to automatically run when the Access database is opened but it won't. Is there another or different macro I could use? Note, in time I'd also like to set the task scheduler to open the file automatically at defined time.

Secondly when I run it manually, I am greeted with an Outlook pop-up window where I have to allow or deny to email to be sent. Is there a way around this?

Secondly, SendObject adding the results of the query as an attachment to the email, is there a way to have the results in the main body of text instead?

Apologies if these questions sound noob!

[pbaldy]

A macro named "autoexec" will run when the database opens. You could put your process there, or use RunCode to call a function that does your process (that's what I do).

There are a number of ways around the security warning. Among them are Outlook Redemption, a free little program called ClickYes, and using CDO to send the email instead of SendObject. I've used the last two with no problems.

You can open a recordset on the query and build an email body using values from the recordset.