public void AddJob(
	string tag,
	string senderEmailPattern,
	EmailAddressCollection recipientsPattern,
	IDataReader mergeDataReader
)

Public Sub AddJob ( 
	tag As String,
	senderEmailPattern As String,
	recipientsPattern As EmailAddressCollection,
	mergeDataReader As IDataReader
)

using System;
using System.Data;
using System.Data.SqlClient;
using MailBee;
using MailBee.Mime;
using MailBee.SmtpMail;

class Sample
{
    // Reports successful attempt of sending e-mail.
    static void mailer_MessageSent(object sender, SmtpMessageSentEventArgs e)
    {
        // Display e-mail address of the successful e-mail.
        // We assume field #0 is ID, field #1 is Email, etc.
        string email = e.MergeDataReaderRowValues[1].ToString();
        Console.WriteLine(string.Format("{0} SUCCEEDED", email));
    }

    // Reports failed attempt of sending e-mail.
    static void mailer_MessageNotSent(object sender, SmtpMessageNotSentEventArgs e)
    {
        // Display e-mail address of the failed e-mail.
        // We assume field #0 is ID, field #1 is Email, etc.
        string email = e.MergeDataReaderRowValues[1].ToString();
        Console.WriteLine(string.Format("{0} FAILED", email));
    }

    static void Main(string[] args)
    {
        // For a change, demostrate that we can pass the license key right here.
        Smtp mailer = new Smtp("MN100-0123456789ABCDEF-0123");

        // Logging into a file is useful for troubleshooting.
        mailer.Log.Filename = @"C:\Temp\log.txt";
        mailer.Log.Enabled = true;
        mailer.Log.Format = LogFormatOptions.AddContextInfo;
        mailer.Log.Clear();

        // Uncomment the line below to use unlimited number of worker threads (up to 60) and increase performance.
        // Note that not all SMTP servers will support so many incoming connections (each thread creates its own).

        // mailer.MaxThreadCount = -1;

        // Subscribe to events to track send bulk mail progress.
        mailer.MessageSent += new SmtpMessageSentEventHandler(mailer_MessageSent);
        mailer.MessageNotSent += new SmtpMessageNotSentEventHandler(mailer_MessageNotSent);

        // Setup SMTP server parameters.
        mailer.SmtpServers.Add("mail.domain.com", "jdoe@domain.com", "secret");

        // Setup e-mail message header template for mail merge.
        mailer.Message.From.AsString = "John Doe <john.doe@domain.com>";
        mailer.Message.To.AsString = "##Name## <##Email##>";
        mailer.Message.Subject = "Our Oct/2013 newsletter";

        // Setup DSN template for mail merge. In particular, this can be useful
        // to track bounced messages which may come back from some addresses after
        // sending bulk mail out. If the SMTP server does not support DSN, this
        // setting will be ignored.
        mailer.DeliveryNotification.TrackingID = "Oct2013_##ID##";

        // Setup HTML body template.
        mailer.Message.BodyHtmlText = "##HTML_body##";

        // For a change, setup plain-text body template. In other samples, we set HTML body only
        // and let MailBee create plain-text version.
        mailer.Message.BodyPlainText = "##Plain_body##";

        // Make outgoing e-mails UTF-8 to allow content in any language.
        mailer.Message.Charset = "UTF-8";

        // The app will take care of plain-text version. MailBee shouldn't do it.
        mailer.Message.Builder.HtmlToPlainMode = HtmlToPlainAutoConvert.Never;

        // Specify database connection string (it may be different in your case).
        string connParams = @"server=(local)\SQLEXPRESS;Initial Catalog=afterlogic;Integrated Security=True";

        using (SqlConnection conn = new SqlConnection(connParams))
        {
            conn.Open();
            using (SqlCommand command = conn.CreateCommand())
            {
                // The 'newsletter' table or query must have these fields:
                // #0: ID (int)
                // #1: Email (nvarchar)
                // #2: Name (nvarchar)
                // #3: Plain_body (nvarchar)
                // #4; HTML_body (nvarchar)
                // Table row example: 15, "jdoe@domain.com", "John", "Some text", "<html>Some&nbsp;text</html>".
                command.CommandText = "SELECT * FROM newsletter";

                // Populate mail merge job to-do list with from the specified table.
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    // Submit the job to MailBee.
                    mailer.AddJob(null, null, null, reader);

                    // Run the job. The actual mail merge takes place here.
                    mailer.SendJobs();

                    Console.WriteLine();

                    // Report results (row indices in the data table) to the console.
                    if (mailer.JobsFailed.Count == 0)
                    {
                        Console.WriteLine(
                            "All of the rows of the table have been processed and sent as e-mails.");
                    }
                    else
                    {
                        if (mailer.JobsSuccessful.Count == 0)
                        {
                            Console.WriteLine(
                                "None of the rows of the table has been processed and sent as e-mail.");
                        }
                        else
                        {
                            Console.WriteLine(
                                "Not all rows of the table have been processed and sent as e-mails.");
                            Console.WriteLine();

                            Console.WriteLine("Successful rows count: " +
                                mailer.JobsSuccessful.Count.ToString());
                            Console.WriteLine();

                            Console.WriteLine("Failed rows count: " +
                                mailer.JobsFailed.Count.ToString());
                        }
                        Console.WriteLine();

                        mailer.JobsSuccessful.Clear();
                        mailer.JobsFailed.Clear();
                    }
                }
            }
        }
    }
}

Imports System.Data
Imports System.Data.SqlClient
Imports MailBee
Imports MailBee.Mime
Imports MailBee.SmtpMail

Class Sample
    ' Reports successful attempt of sending e-mail.
    Private Shared Sub mailer_MessageSent(sender As Object, e As SmtpMessageSentEventArgs)
        ' Display e-mail address of the successful e-mail.
        ' We assume field #0 is ID, field #1 is Email, etc.
        Dim email As String = e.MergeDataReaderRowValues(1).ToString()
        Console.WriteLine(String.Format("{0} SUCCEEDED", email))
    End Sub

    ' Reports failed attempt of sending e-mail.
    Private Shared Sub mailer_MessageNotSent(sender As Object, e As SmtpMessageNotSentEventArgs)
        ' Display e-mail address of the failed e-mail.
        ' We assume field #0 is ID, field #1 is Email, etc.
        Dim email As String = e.MergeDataReaderRowValues(1).ToString()
        Console.WriteLine(String.Format("{0} FAILED", email))
    End Sub

    Shared Sub Main(args As String())
        ' For a change, demostrate that we can pass the license key right here.
        Dim mailer As New Smtp("MN100-0123456789ABCDEF-0123")

        ' Logging into a file is useful for troubleshooting.
        mailer.Log.Filename = "C:\Temp\log.txt"
        mailer.Log.Enabled = True
        mailer.Log.Format = LogFormatOptions.AddContextInfo
        mailer.Log.Clear()

        ' Uncomment the line below to use unlimited number of worker threads (up to 60) and increase performance.
        ' Note that not all SMTP servers will support so many incoming connections (each thread creates its own).

        ' mailer.MaxThreadCount = -1;

        ' Subscribe to events to track send bulk mail progress.
        mailer.MessageSent += New SmtpMessageSentEventHandler(AddressOf mailer_MessageSent)
        mailer.MessageNotSent += New SmtpMessageNotSentEventHandler(AddressOf mailer_MessageNotSent)

        ' Setup SMTP server parameters.
        mailer.SmtpServers.Add("mail.domain.com", "jdoe@domain.com", "secret")

        ' Setup e-mail message header template for mail merge.
        mailer.Message.From.AsString = "John Doe <john.doe@domain.com>"
        mailer.Message.[To].AsString = "##Name## <##Email##>"
        mailer.Message.Subject = "Our Oct/2013 newsletter"

        ' Setup DSN template for mail merge. In particular, this can be useful
        ' to track bounced messages which may come back from some addresses after
        ' sending bulk mail out. If the SMTP server does not support DSN, this
        ' setting will be ignored.
        mailer.DeliveryNotification.TrackingID = "Oct2013_##ID##"

        ' Setup HTML body template.
        mailer.Message.BodyHtmlText = "##HTML_body##"

        ' For a change, setup plain-text body template. In other samples, we set HTML body only
        ' and let MailBee create plain-text version.
        mailer.Message.BodyPlainText = "##Plain_body##"

        ' Make outgoing e-mails UTF-8 to allow content in any language.
        mailer.Message.Charset = "UTF-8"

        ' The app will take care of plain-text version. MailBee shouldn't do it.
        mailer.Message.Builder.HtmlToPlainMode = HtmlToPlainAutoConvert.Never

        ' Specify database connection string (it may be different in your case).
        Dim connParams As String = "server=(local)\SQLEXPRESS;Initial Catalog=afterlogic;Integrated Security=True"

        Using conn As New SqlConnection(connParams)
            conn.Open()
            Using command As SqlCommand = conn.CreateCommand()
                ' The 'newsletter' table or query must have these fields:
                ' #0: ID (int)
                ' #1: Email (nvarchar)
                ' #2: Name (nvarchar)
                ' #3: Plain_body (nvarchar)
                ' #4; HTML_body (nvarchar)
                ' Table row example: 15, "jdoe@domain.com", "John", "Some text", "<html>Some&nbsp;text</html>".
                command.CommandText = "SELECT * FROM newsletter"

                ' Populate mail merge job to-do list with from the specified table.
                Using reader As SqlDataReader = command.ExecuteReader()
                    ' Submit the job to MailBee.
                    mailer.AddJob(Nothing, Nothing, Nothing, reader)

                    ' Run the job. The actual mail merge takes place here.
                    mailer.SendJobs()

                    Console.WriteLine()

                    ' Report results (row indices in the data table) to the console.
                    If mailer.JobsFailed.Count = 0 Then
                        Console.WriteLine("All of the rows of the table have been processed and sent as e-mails.")
                    Else
                        If mailer.JobsSuccessful.Count = 0 Then
                            Console.WriteLine("None of the rows of the table has been processed and sent as e-mail.")
                        Else
                            Console.WriteLine("Not all rows of the table have been processed and sent as e-mails.")
                            Console.WriteLine()

                            Console.WriteLine("Successful rows count: " & mailer.JobsSuccessful.Count.ToString())
                            Console.WriteLine()

                            Console.WriteLine("Failed rows count: " & mailer.JobsFailed.Count.ToString())
                        End If
                        Console.WriteLine()

                        mailer.JobsSuccessful.Clear()
                        mailer.JobsFailed.Clear()
                    End If
                End Using
            End Using
        End Using
    End Sub
End Class