Send Individually Addressed Newsletter
Previous Topic  Next Topic 



This example demonstrates how to send a Newsletter email to a list of "To:" recipients whose email addresses are retrieved from a DSN named "XL2K", which is connected to a Microsoft Excel file. The data source has a table named "customer". The table has a column named "email" which contains each the email addresses. Each email will be personally addressed to each recipient ("To:") by using the -recipientlimit parameter set to 1 in combination with the -dbuseaddressee parameter set to "to".


Prepared Example Files



The archive contains two files:



Batch File Contents


This is the content of the batch file:


NetMailBot -to -from -server -dsn "DSN=XL2K" -dbtable "customer" -dbemailcolumn "email" -dbuseaddressee "to" -recipientlimit 1 -subject "Here is your Monthy Newsletter" -bodyfile "Newsletter.txt" -logfile "logfile.txt" -debug 




  1. Unzip the file. This will produce a directory called "IndividualNewsletter". Open this directory.
  2. Open Notepad and edit the batch file "IndividualNewsletter.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. Check your email account Inbox for an email containing the text newsletter body. You should be the only recipient listed in the "To:" field. Using -recipientlimit 1 ensures that the mails are individually addressed.