Code to send Mail through Oracle

CREATE OR REPLACE PROCEDURE send_mail (p_to IN VARCHAR2, p_from IN VARCHAR2, p_message IN VARCHAR2, p_smtp_host IN VARCHAR2, p_smtp_port IN NUMBER DEFAULT 25) AS l_mail_conn UTL_SMTP.connection; BEGIN l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);–Host name and port number of SMTP UTL_SMTP.helo(l_mail_conn, p_smtp_host); — SMTP Host Name UTL_SMTP.mail(l_mail_conn, p_from); — from mail id UTL_SMTP.rcpt(l_mail_conn, p_to); — to mail id UTL_SMTP.data(l_mail_conn,…

Details

Sending mail in VB6 using SMTP

Mail Without Attachment Dim mail As New MailMessage() mail.To = “tomailid@mailer.com” mail.From = “frommailid@mailer.com” mail.Subject = “Enter any subject here.” mail.BodyFormat = MailFormat.Html mail.Body = “Mail body here” SmtpMail.SmtpServer = “localhost” ‘smtp server details SmtpMail.Send(mail) Mail With Attachment Dim mail As New MailMessage() mail.To = “tomailid@mailer.com” mail.From = “frommailid@mailer.com” mail.Subject = “Enter any subject here.”…

Details