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 email@example.com -from firstname.lastname@example.org -server smtp.test.com -dsn "DSN=XL2K" -dbtable "customer" -dbemailcolumn "email" -dbuseaddressee "to" -recipientlimit 1 -subject "Here is your Monthy Newsletter" -bodyfile "Newsletter.txt" -logfile "logfile.txt" -debug