auto emailing reports

[CHAOSinACT]

ok i have a database with tables on the server, front end (forms/reports) on local machines. I now need to have a checkbox on form that initiates an automatic email to our accountant. i can do everything else, never tried to get access to send an email... needs to work on different computers but all have email access... don't want the user to even know about the process so all vba if possible... any advice???? need it done in a couple days...

 

[apr pillai]

Take a look at the following link:

http://www.msaccesstips.com/2007/11/automated-email-alerts.shtml