Import From a Database

Parameters to use...

  • NetMailBot can import mailing lists from any ODBC compliant database such as Microsoft Access, Microsoft Excel, Microsoft SQL Server, Oracle, and others.
  • To connect to your existing database, you will need to follow a few simple steps:
    There are four database parameters needed for using a database:
    • -dbquery
      • This parameter specifies the database query to import email addresses from. For example, the query should be a SELECT statement that includes the column that contains the email address, e.g. "SELECT * from List" OR "SELECT emailAddress from List"
    • -dbtable
      • This parameter specifies the database table where email addresses are stored.
    • -dbemailcolumn
      • This parameter specifies the column name that contains email addresses.
    • -dbuseaddressee
      • This parameter specifies the addressee to use, "to", "cc", or "bcc".
    • -dsn
      • This parameter specifies the dsn (data source name) to use for the database

Example

Click Here to view a complete working example