send email from query

I have a query that returns records based on  a date diff. one of the fields returned in the record is email
address. I would like to auto send an email based on the query returns saying "your reservation will
expire in 2 days".


tmurray22
tmurray22Asked:
Who is Participating?
 
Éric MoreauSenior .Net ConsultantCommented:
vbSendMail can be used for vbScript. There is an example of that in the download.
0
 
Éric MoreauSenior .Net ConsultantCommented:
for my e-mail needs in VB6, I always use http://www.freevbcode.com/ShowCode.Asp?ID=109
0
 
SethiCommented:
I second emoreau. This is the best email component available. Also look at the following link which provides a very good example of how to use vbSendmail component:
http://www.freevbcode.com/ShowCode.Asp?ID=5796
0
 
tmurray22Author Commented:
But I'm using vbscript ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.