What event do you want to use to run process of sending email? You should just run a report daily that shows this info.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Doesn't answer my question.
Code has to be in some event - such as a button click or form open. Code could loop through a recordset and send email for records that meet criteria or send one email with report attached. Sending emails is a common topic. Search forum.
Simplest approach is to just open a filtered report.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.