using System;
using System.Data;
using System.Data.Odbc;
using Dimac.JMail;

namespace JMailTest
{
  class MainClass
  {
    [STAThread]
    static void Main( string[] args )
    {
      // create mailmerge instance
      MailMerge mm = new MailMerge();

      // setup template
      mm.Template.From = "me@mydomain.com";
      mm.Template.To.Add( "<%# EmailAddress %>", "<%# Name %>" );
      mm.Template.Subject = "Hello <%# Name %>";
      mm.Template.BodyText = "Hello there <%#  Name %>. This is your e-mail address: <%# EmailAddress %>!";

      // set output directory               
      mm.OutputDirectory = "C:\\MailServer\\Pickup";
             
      // open sql connection   
      using( OdbcConnection connection = new OdbcConnection( "DSN=MyDSN" ) )
      using( OdbcCommand command = new OdbcCommand( "SELECT EmailAddress, Name FROM Contacts", connection ) )
      {
        connection.Open();
        // get data reader         
        using( IDataReader reader = command.ExecuteReader() )
        {
          // set data source
          mm.DataSource = reader;

          // databind!
          MailMergeResult result = mm.DataBind( false );

          Console.WriteLine( "Success: {0}, Failure: {1}", result.SuccessCount, result.FailureCount );
        }
      }
    }
  }
}