 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2007send email
hi all my problem is that.. i have a database with one table including 3 check boxes. what i want is when the three check boxes are filled to automatically send an email in a pre-defined adrress. the e-mail will contain a text written by me and it will be the same each time.. can you please tell me the querry or the macro to do this??? thanks in advance... >hi all > [quoted text clipped - 11 lines] > >thanks in advance... Neither a query nor a macro can do this. If you are updating the table datasheet directly, you cannot do this. If you instead base a Form on the table, you can use VBA code in the form's AfterUpdate event to send an email. See the VBA help for SendObject. John W. Vinson [MVP] i forgot something important to mantion.. the database is linked with a infopath form. the idea is the user to fill the check boxes in the infopath form and the date base will collect the entries.. so far so good. but i want when the check boxes in the data base are filled (via infopath) to send an email as we said previously... any ideas?? > >hi all > > [quoted text clipped - 20 lines] > > John W. Vinson [MVP] >i forgot something important to mantion.. > [quoted text clipped - 6 lines] > >any ideas?? Since Infopath is managing the data, and Access has no control over it, I'd suggest that you use the Infopath program to send the email. You may need to ask in an Infopath forum. I've never used that program and don't know what to suggest. John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.