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

Who is Participating?
Éric MoreauSenior .Net ConsultantCommented:
vbSendMail can be used for vbScript. There is an example of that in the download.
Éric MoreauSenior .Net ConsultantCommented:
for my e-mail needs in VB6, I always use
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:
tmurray22Author Commented:
But I'm using vbscript ?
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.