This example demonstrates how to send email to a list of email addresses contained in a Microsoft Excel spreadsheet.
Using this feature requires Microsoft Excel, in order to be able to edit the Excel spreadsheet as described below, and the latest ODBC drivers, obtainable at the Microsoft website.
Create an Excel Spreadsheet
Create an ODBC DSN
Create a batch file
"c:\program files\netmailbot\netmailbot.exe" -to "firstname.lastname@example.org" -server "mail.changeme.com" -dsn "DSN=example" -dbtable "customer" -dbemailcolumn "email" -dbuseaddressee "to" -recipientlimit 1 -from "email@example.com" -subject "test" -logfile "logfile.txt" -debug
NOTE: If you use your own email address in the spreadsheet as described above, your email account should receive three emails - one for the fact that you are listed in the -to parameter and two more for the two email addresses found in the spreadsheet (both being your email address) and the use of -recipientlimit 1.