What you need?
1) a server running a java enabled operating system.
2) Java 1.7 or greater.
3) Apache Tomcat 5.5 or greater.
4) a MySQL empty database to use.
5) access to an SMTP server to send emails.
6) the Auto SQL Mailer ... get it here!
How it works?
1) create a database connection. Oracle, MySQL, MSSQL, IBM AS400 are already supported, you can add your own JDBC compliant database driver.
2) create a SQL query on the previous created connection, 1 record is 1 email.
3) the system will get the fields from the query.
4) compose the template for your email message using an integrated editor, you can compose like in Mail Merge for Microsoft Word.
5) now you can see the generated email for the first record.
6) optional: write a sql query to be executed after the send.
7) schedule the send when you want.
You can create multiple connections on different databases, create multiple queries, create multiple templates and
schedule multiple sends.
Enjoy it!!
Features
- Schedule
- Enterprises
- Java
- SQL