send email

[Osyris]

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...

 

[John W. Vinson]

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...

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]

 

[Osyris]

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??

 

[John W. Vinson]

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??

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]