Question on sending Email Alert msg

[ChoonHong]

Hi All, I have a question on sending Email alert msg.

I have this form whereby user would enter all the fields required, and when press the "Add" button, it would insert all these fields to the database as well as sending out alert msg to the email.

I have no problem inserting the fields to the database, but how do I send email as well when clicking the "Add" button?

I have search through the net and found that most sending email alert, you need to design a form based to let end user fill up the form than send the email out but I would like it to be automated sending out email msg. Can someone enlighten me how should I approach this?

 

[Andrzejek]

Take a look at How to schedule a mail. You have some sample code to send an e-mail from VB6, it should also work in VBA.

This sample talkes about the info from a text file, but you can use a database as well.

Have fun.

---- Andy

 

[PHV]

If you're working with access VBA then have a look to the DoCmd.SendObject method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886