Access to send automated email

You can use:

DoCmd.SendObject

In your forms toolbox, click on the bottom right icon to add additional controls. Add Microsoft MAPI Message Control and Microsoft MAPI Session Control.

For a more detailed how-to on mapi, check out this site:

http://my.execpc.com/~dg/tutorial/howmapi/howmapi.htm

(no space in url)

It gives a sample using VB 4 but it works with vba :)

hope this helps.

Have a look at

http://www.granite.ab.ca/access/email.htm

for VBA code for sending email help. Then just call the appropriate functions (provided) within your code (or execute it within a timer or automated PC event...