using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Net.Mail;

public partial class StoredProcedures
{
    [Microsoft.SqlServer.Server.SqlProcedure]
    public static void PLSendMail(string server, string from, string recipients, string subject, string body)
    {
        using (MailMessage message = new MailMessage(from, recipients))
        {
            message.Subject = subject;
            message.Body = body;
            message.IsBodyHtml = true;
            SmtpClient client = new SmtpClient(server);
            client.Send(message);
        }
    }
};