Category:

 

Mail Merge

 

Description: 

 

Acts much like -dbreplacementids except the defined tokens are replaced by the constants specified.

 

Optional?

 

Yes.

 

Overrides:

 

None.

 

Overridden By:

 

None.

 

Other Parameters Required:

 

-to (required if -dbuseaddressee is NOT "to") -from -server

 

See Also:

 

-dbemailcolumn -dbusecolumnindex -dbquery -dbtable -dbuseaddressee -dsn -personalize -dbreplacementids -dbupdatequery

 

Usage:

 

-dbconstants "<delimiter><first id name><delimiter>=<first column name>, <delimiter><second id name><delimiter>=<second column name> [...]"

 

Specify replacement ids wrapped with delimiters such as << and >> so for example an id "first_name" would appear  as <<first_name>>. Each id is followed by an equals sign, then the name of the corresponding column name. Separate multiple replacement identifiers with a comma. 

 

Example (cut-and-paste right into your batch file):

 

NetMailBot -dsn "mydb" -dbquery "SELECT * FROM Customers" -dbemailcolumn "email" -dbconstants "<<first_name>>=first_name" -to email@domain.com -from email@domain.com -server mail.domain.com -subject "test"  

 

Comments:

 

Can be used in conjunction with -dbreplacementids.