How to have Access automatically sending email when a criteria is met? 1

[Spruce4U]

I want my DB to inform the person responsible for orders when enough records have been added.

What is the command to send E-mail automatically with VBA?

Thanks

 

[PHV]

Docmd.SendObject

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Spruce4U]

Perfect PHV, it works.

However, a warning appears that says that a program is attempting to send email in your name and that allows the user to stop the sending. Is there a way to turn that warning off?

Many thanks,

Sébastien

 

[PHV]

Do a google search for outlook object model guard

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Spruce4U]

I'm impressed!

Huge thanks for the fast and pro answer.