Need to send results of a query via email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks Chris,

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

Regards
S
 
Back
Top