Create and send personalized e-mails to your clients using data from your database!
Generate 1000s personalized e-mails to improve customer satisfaction!
Use data from almost any source: Access, SQL Server, Oracle, PostgreSQL, MySQL, SQLite…
Send messages continuously or once per specified time interval!
Make your messages stand-out using HTML and attachments!
Save time with message templates that you can store for future use!
Set up once and then use multiple e-mail accounts and data sources.
How it Works
Specify Data Source
First, using the tools provided by the product, you select specific records that contain certain information about your clients (like name, e-mail address, etc.) from your existing database that you want to use to compose your personalized e-mails.
Setup E-Mail Account & Write Your Message
Then you specify the e-mail account from which you wish to send the emails.
Once the email account is setup, compose the e-mail message you want to send using special placeholders in place of names and other dynamic data.
Finally the program will generate personalized e-mails replacing the placeholders in your message template with real data, and it will then send the generated e-mail messages using e-mail account and settings of your choice.
Generate Personalized Messages Dynamically
As was already mentioned the program uses placeholders that you insert in your e-mail message template to personalize e-mails it generates. Basically, once it has retrieved the data from your database, it will generate an e-mail for every record (row in a table), using your e-mail template, where it will replace all placeholders it finds with the data from that data record. So, for example, if in your template you include text Dear %firstname%, where %firstname% is a placeholder, the program will replace it with the data taken from the column with the same name (in this case the column named firstname); and thus if the current record has Michael as the value for this column, the generated text will be Dear Michael.
Enrich Your Messages with HTML Markup
You can send both text-only and HTML-based messages with this program. Additionally you can specify message and subject encodings such as UTF or ASCII, etc., as well as e-mail priority. What’s more is that you can also specify different values for to, CC, and BCC fields!
Send Messages in 2 Different Ways
The program supports two different sending modes: continuous and time interval-based. In continuous mode, as soon as the program has finished sending one message, it will start sending the next one. In time interval-based mode, on the other hand, the program sends messages only once per specified amount of time – like sending e-mail message every 5 seconds. The latter option is handy if your SMTP e-mail server has restrictions on the number of e-mails you can send within a given time period.
Exclude Certain E-Mail Addresses - Temporarily or Permanently
The product also lets you to exclude certain e-mail addresses, so that e-mails will never be sent to them, even if they are present in the records retrieved by the program from your database. In fact you can specify permanently blocked e-mail addresses, as well as temporary. What’s more is that there is an option to prevent sending duplicate e-mails. This is useful if the same e-mail address appears more than once in the records retrieved by the program from your database.
Track your E-Mail Campaigns!
The program automatically stores information about your e-mail campaigns, such as: when you sent it, how many e-mails were sent, what you sent, etc.
The product lets you retrieve desired data from a variety of sources. In fact it supports any ODBC-compliant data source, such as Microsoft Access database, SQL Server or Oracle databases, or any other. If in doubt as to whether you can import your data into the program, feel free to contact us. The data is imported into the program using two simple steps.
First, you setup the data source (define the file path to the database, if it’s file-based, provide needed login information, etc.) by composing what’s called a connection string (you can learn more about connection strings here). You can then save that information in an encrypted format for future use by the program.
Secondly, you simply write SQL SELECT statement that will retrieve the desired records from your database. It could be as simple as SELECT * FROM Customers, or much more complex – you can use whatever your data source supports. If you do not know how to write SQL statements, do not worry, they are easy to learn and will benefit you greatly. You can learn more about them here.
The program also lets you to send attachments with your messages. This way you can send even more information to your prospective clients.
Save Time with Message Templates and Stored E-Mail Accounts
You only need to set up the program once. For instance, you can let the program store details of your e-mail account, data source, and data selection statement. You can also easily set up multiple e-mail accounts, data sources, and create as many data selection statements as you wish - the program will automatically remember all of that!
What's more is that you can save entire e-mail messages as templates for future use, thus saving you a good deal of time!
Avoid Duplicate E-Mails being Sent!
The program can automatically determine if it has already sent a message to a particular e-mail address within a single campaign, and if so, it will not send another copy (even though there may be a corresponding database record). But of course, you can turn off this option, if you desire!
Get Full Control with Various E-Mail and SMTP Options
You can use as many e-mail accounts as you want in this product. All e-mail accounts that you register with the program can be saved in an encrypted form for better security. For each e-mail account you can specify regular setting like server address, login, and password, as well as some additional ones: outgoing port, SSL support, reply-to e-mail address, and some others. Please note, that currently only SMTP e-mail accounts are supported.
Import data from any ODBC-compliant data sources: MS Access, SQL Server, Oracle, MySQL, SQLite...
Save data sources, so you won't need to re-enter connection information again
Use SELECT SQL statements to retrieve data from databases
Save SELECT SQL statements for future use
Manually remove and modify retrieved records from the program by editing them in a data grid
Define default values for placeholders, in case record would be empty or NULL
Support for SMTP e-mail accounts
Set up and save e-mail accounts for future use
Sensitive data that you decide to save such as e-mail account and data source passwords can be encrypted
Support for message templates
Support for attachments
Support for various message encodings
TO, CC, and BCC e-mail fields
Preview e-mail messages before they are sent
Send e-mails continuously or every specified amount of time
Avoid duplicate e-mail being sent
History of e-mail campaigns
FirstSQL.com - Learn the basics of SQL SELECT statements that you can use in Database E-Mailer to achieve maximum results.