Visual C++ - Email queue with EASendMail Service - database

The following c++ example codes demonstrate how to pick recipients from database and send email using email queue. In the example, we used C:\Program Files\EASendMailService\easendmail_demo.mdb as sample MS Access Database.

SMTP Queue Service

EASendMail Service is a light and fast email delivery service which works with EASendMail SMTP Component to enable your application to send mass emails in background queue service.

Along with its ability to picking recipients from database in background and sending email in specified datetime, it eases your task in developing featured email application such as newsletter application. We strongly recommend you to use EASendMail Service with your ASP.NET/Web Application.

Important

To work with EASendMail Service, please download EASendMail and EASendMail Service at first, and then install both on your machine. If you are using web hosting service and you don’t have permission to install service on that server, EASendMail service is not suitable for you.

With EASendMail email queue feature, you do not have to code for multiple threadings. EASendMail Service can send email in background with multiple threadings automatically. You just need to adjust the maximum worker threads in EASendMail Service Manager to increase the performance. Please click here to learn more detail about EASendMail Service.

Another typical usage scenario is that most newsletter applications get recipient name and address from database. To simplify the task of developer, EASendMail provides a very powerful way to select recipients from database automatically.

c++ email queue + database

Installation

EASendMail is a SMTP component which supports all operations of SMTP/ESMTP protocols (RFC 821, RFC 822, RFC 2554). Before you can use the following example codes, you should download the EASendMail Installer and install it on your machine at first.

Add reference

To use EASendMail SMTP ActiveX Object in your C++ project, the first step is “Add header files of EASendMail to your project”. Please go to C:\Program Files\EASendMail\Include\tlh or C:\Program Files (x86)\EASendMail\Include\tlh folder, find easendmailobj.tlh and easendmailobj.tli, and then copy these files to your project folder.

add reference in Visual C++

MS Access x64 Driver

If your Windows is x64 bit, please download and install MS Access x64 Driver on your server and please change X-Data-Connection like this:

oSmtp->AddHeader(_T("X-Data-Connection"),
    _T("Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq={$var_easendmailpath}\\easendmail_demo.mdb;Uid=;Pwd=;"));

MS Access Database x64 Driver Download

Microsoft Access Database Engine 2010 Redistributable

C++ - Send email to queue service - database

The following example codes demonstrate sending email message using email queue + database. In order to run it correctly, please change SMTP server, user, password, sender, recipient value to yours.

Note

To get full sample projects, please download and install EASendMail on your machine.

#include "stdafx.h"
#include <tchar.h>
#include <Windows.h>

#include "EASendMailObj.tlh"
using namespace EASendMailObjLib;

const int ConnectNormal = 0;
const int ConnectSSLAuto = 1;
const int ConnectSTARTTLS = 2;
const int ConnectDirectSSL = 3;
const int ConnectTryTLS = 4;

int _tmain(int argc, _TCHAR* argv[])
{
    ::CoInitialize(NULL);

    IMailPtr oSmtp = NULL;
    oSmtp.CreateInstance(__uuidof(EASendMailObjLib::Mail));
    oSmtp->LicenseCode = _T("TryIt");

    // Set your sender email address
    oSmtp->FromAddr = _T("test@emailarchitect.net");

    // Set email subject
    oSmtp->Subject = _T("simple email from Visual C++ email database queue");

    // EASendMail will use the following connection to connect to the database,
    // the syntax is same as ADO connection object.
    oSmtp->AddHeader(_T("X-Data-Connection"),
    _T("Driver={Microsoft Access Driver (*.mdb)};Dbq={$var_easendmailpath}\\easendmail_demo.mdb;Uid=;Pwd=;"));

    // EASendMail will select the fields by the following sql statement
    // before sending email,
    // then pick the recipient address from specified field.
    oSmtp->AddHeader(_T("X-Sql-Select"), _T("SELECT id, name, address FROM Recipients"));

    // Pick "name" field as the recipient name and "address" field as the recipient address.
    // You can also use {$var_srecord:fieldname} to pick any field in X-Sql-Select statement
    // and put it to subject, bodytext, then EASendMail will replace it automatially.
    oSmtp->DisplayTo = _T("\"{$var_srecord:name}\" <{$var_srecord:address}>");
    oSmtp->AddHeader(_T("X-Rcpt-To"), _T("{$var_srecord:address}"));

    // EASendMail service will execute the following sql statement on
    // every email was sent successfully.
    oSmtp->AddHeader(_T("X-Sql-OnSentSuccess"),
    _T("INSERT INTO sentlog (server, email) VALUES('{$var_server}', '{$var_rcptaddr}')"));

    // EASendMail service will execute the following sql statement on
    // every email could not be sent.
    oSmtp->AddHeader(_T("X-Sql-OnSentError"),
    _T("INSERT INTO errorlog(email, server, errorcode, errordescription)")
    _T("VALUES('{$var_rcptaddr}', '{$var_server}', '{$var_errcode}', '{$var_errdesc}')"));

    _bstr_t bodytext;

    bodytext = "Hi {$var_srecord:name}\r\n";
    bodytext += "Send email with queue.\r\n\r\n";
    bodytext += "From:Tester\r\n";
    // {$var_srecord:address} will be replaced by EASendMail automatically.
    bodytext += "To:{$var_srecord:address}\r\n\r\n";
    bodytext += "Your id in database is {$var_srecord:id}.\r\n";

    oSmtp->BodyText = bodytext;

    // Your SMTP server address
    oSmtp->ServerAddr = _T("smtp.emailarchitect.net");

    // User and password for ESMTP authentication, if your server doesn't
    // require User authentication, please remove the following codes.
    oSmtp->UserName = _T("test@emailarchitect.net");
    oSmtp->Password = _T("testpassword");

    // Most mordern SMTP servers require SSL/TLS connection now.
    // ConnectTryTLS means if server supports SSL/TLS, SSL/TLS will be used automatically.
    oSmtp->ConnectType = ConnectTryTLS;

    // If your SMTP server uses 587 port
    // oSmtp->ServerPort = 587;

    // If your SMTP server requires SSL/TLS connection on 25/587/465 port
    // oSmtp->ServerPort = 25; // 25 or 587 or 465
    // oSmtp->ConnectType = ConnectSSLAuto;

    _tprintf(_T("Start to send email ...\r\n"));

    if(oSmtp->SendMailToQueue() == 0)
    {
        _tprintf(_T("email was sent to queue successfully!\r\n"));
    }
    else
    {
        _tprintf(_T("failed to send email with the following error: %s\r\n"),
            (const TCHAR*)oSmtp->GetLastErrDescription());
    }

    return 0;
}

TLS 1.2 protocol

TLS is the successor of SSL, more and more SMTP servers require TLS 1.2 encryption now.

If your operating system is Windows XP/Vista/Windows 7/Windows 2003/2008/2008 R2/2012/2012 R2, you need to enable TLS 1.2 protocol in your operating system like this:

Enable TLS 1.2 on Windows XP/Vista/7/10/Windows 2008/2008 R2/2012

32bit/x64 ActiveX DLL

Seperate builds of run-time dll for 32 and x64 platform

File Platform
Installation Path\Lib\native\x86\EASendMailObj.dll 32 bit
Installation Path\Lib\native\x64\EASendMailObj.dll 64 bit

Distribution

  • Standard EXE

    For VB6, C++, Delphi or other standard exe application, you can distribute EASendMailObj.dll with your application to target machine without COM-registration and installer. To learn more detail, please have a look at Registration-free COM with Manifest File.

  • Script

    For ASP, VBScript, VBA, MS SQL Stored Procedure, you need to install EASendMail on target machine by EASendMail installer, both 32bit/x64 DLL are installed and registered.

Appendix

Comments

If you have any comments or questions about above example codes, please click here to add your comments.