This example demonstrates how to send an email using the mail merge features in NetMailBot, while using two database tables. The notable aspect of this example is that -dbquery uses a SQL Join to query data from two tables to be used in the mail merge. The database used is an MS Access database (Access 2000 version) which contains some sample data.
NOTE: You should change the email addresses in the Access database to your own email address(es) before running a test.
Using this feature requires Microsoft Access and working knowledge of creating and editing an MS Access database. Also required is understanding of basic SQL concepts including multi-table joins.
Prepared Example Files
The -bodyfile parameter in NetMailBot uses full paths. We have assumed a particular path as shown in the batch file contents below. Therefore, download this file to C:\tmp on your hard drive or edit the -bodyfile parameter to reflect wherever you unzip the archive.
The archive contains two files:
Batch File Contents
This is the content of the batch file:
netmailbot -to email@example.com -from firstname.lastname@example.org -subject "Mail Merge Example" -server localhost -logfile c:\tmp\log.txt -dsn "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\tmp\test.mdb" -dbquery "SELECT Customers.first_name, Customers.last_name, Email.email FROM Customers, Email WHERE Customers.ID = Email.customer_id" -dbemailcolumn "email" -dbreplacementids "<<first_name>>=first_name,<<last_name>>=last_name" -body "<<first_name>> <<last_name>>" -personalize