Query results into email

[Ken Barz]

Hi,

I'm working on a program that will periodically run a
query on a SQL database. What I would like it to do is to
automatically take the results of that query (should be
only a couple of lines at a time,) add that information to
the body of an email and automatically send it.

Any idea of how to do the email piece of this? I'm
assuming it will be via SMTP.

Thanks,Ken

 

[Ken Tucker [MVP]]

Hi,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvssamp/html/vbcs_SendMail.asp

Ken