Need to send results of a query via email

[Grd]

Hi there,

When I open up my database I would like it to automatically run a query and
if there are any results these are automatically sent via email.

I don't know or if this can be done but I desperately need to figure this out.

Any help would be greatly appreciated.

Thanks

Susanne

 

[Chris Reveille]

You could use a macro
use the sendobject command
in the condition portion of the sendobject action put
DCount("*","queryname")>0

Name the macro Autoexec

 

[Grd]

Thanks Chris,

Just stared to play with it your suggestion. I think thats what I need.

Regards
S