Send Emails Using SQL Server and rs.EOF redirection
Posted on 2003-11-05
I am not an expert in SQL Server, however, I know how to use it in a simple way. I created the tables, relationships, connectivity, etc. I really did not try using Mail from SQL Server but need to do it badly. I have Outlook installed for MAPI.
Could somebody tell a simple good way of how I can send emails once smb adds a new record it a table.
Also, additional question: if rs.EOF <> true then how can I send a user back prompting for correct input and displaying a short message like "make sure you enter correct data"?
Thank you for your time.