Connect to access table, run sql statement and email results using vb script

I need a script that will connect to an access table and run a query or a select statement and if records are returned from a sql statement then i need to email results using microsoft outlook.

tvaeAsked:
Who is Participating?
 
tvaeAuthor Commented:
It has to be a script and have found a solution using ADODB connection and then using CDO message to send email
0
 
Patrick MatthewsCommented:
Does this have to run from VBScript, or can it simply be a VBA routine run from Access?
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.