Purpose

 

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:

 

• IndividualNewsletter.bat - The batch file that will instruct NetMailBot to send the email message.
• Book1.xls - The list of subscribers stored in a Microsoft Excel file.
• Newsletter.txt - The newsletter message body.

 

Batch File Contents

 

This is the content of the batch file:

 

NetMailBot -to test@test.com -from test@test.com -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 

 

Steps

 

1. Unzip the IndividualNewsletter.zip 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:

 

• Change the parameters -to and -from to your email address.
• Change the parameter -server to your own mail server.

• You can change the dummy addresses in the .xls file if you like.

 

3. Invoke the batch file by double-clicking the icon or straight from the command line.
4. 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.