Sending a Message via E-Mail

[m17347047711116]

i have a Form where i log accident reports, the reports require action / response from certain people within 3 days.

my thaughts are run a query on a daily basis maybe autorun that searches for [Date initiated] that are more than 3 days old and pulls out the selected records.

send the results of the query via e-mail using a command that defines recipients and sends query or report automatic to everyone.

Any Thaughts help is greatly appreciated
Thankyou in advance

 

[WayneRyan]

m,

Hayler Baxter has a nice example of email:

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=186951

Wayne