SQL Queries for Working with External Databases or Files |
Indexsoft Intuitive Mailer provides support for using external databases or files. For example, you have software to collect and store emails for some web-site. This software is integrated into the web-site, and it is not possible for you to revise the existing code so that the web-site can work with Indexsoft Intuitive Mailer. Indexsoft Intuitive Mailer can easily process external databases or files with user data.
To add a SQL query to the database, you should provide database name, data source, username and password as it appears in DBI->connect() method. The query must return user name as the first value, user email as the second value in a row.
In the SQL query list you can select queries to delete, or prepare a message to dispatch to those users fetched by the selected query.