Access Database and Simple Body
Previous Topic  Next Topic 



This example demonstrates how to send an email using the mail merge features in NetMailBot. 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. 


Additional Prerequisites


Using this feature requires Microsoft Access and working knowledge of creating and editing an MS Access database.


Prepared Example Files



The archive contains two files:



Batch File Contents


This is the content of the batch file:


netmailbot -to -from -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 * FROM Customers" -dbemailcolumn "email" -dbreplacementids "<<first_name>>=first_name,<<last_name>>=last_name" -body "<<first_name>> <<last_name>>" -personalize




  1. Unzip the file. This will produce a directory called "MailMergeAccessSimple". Open this directory.
  2. Open the Access database.
  3. Change all of the email addresses to your email address (for the purposes of this test run, they can all be the same).
  4. Close the Access database.
  5. Open Notepad and edit the batch file "MailMergeAccessSimple.bat". Note these important parameters used in the batch file:
  1. Invoke the batch file by double-clicking the icon or straight from the command line.
  2. NetMailbot should start up and, upon finishing, the email addresses specified with the -to parameter should each receive an email message.