Send Emails From A MS-SQL Stored Procedure
Version Compatibility: Visual Basic 6
This snippet can be used to send emails through a MS-SQL stored procedure. It instantiates the CDONTS.NewMail object via sp_OACreate system stored procedure.
Instructions: Copy the declarations and code below and paste directly into your VB project.