Need to send results of a query via email


G

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
 
Ad

Advertisements

C

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
 
Ad

Advertisements

G

Grd

Thanks Chris,

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

Regards
S
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top