-dbquery (-dbq)
Previous Topic  Next Topic 

Category:

 

Database Connectivity

 

Description: 

 

Specifies the SQL query for NetMailBot to execute when using the database and mail merge commands.

 

Optional?

 

Yes.

 

Overrides:

 

None.

 

Overridden By:

 

None.

 

Other Parameters Required:

 

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

 

See Also:

 

-dbemailcolumn -dbusecolumnindex -dbreplacementids -dbtable -dbuseaddressee -dsn -dbupdatequery -dbconstants

 

Usage:

 

-dbquery "<SQL query string>"

 

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

 

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

 

Comments:

 

None.