The main marketing process is emailing. To launch an emailing campaign, you need to collect names with email addresses. These email addresses corresponding to prospect names will generally be stored on a mySQL table. Our emailing strategy allows for these name/email address pairs to be picked up from any part of the mySQL database, using an SQL select query , which is defined as part of the mailing list.
We have two separate table. One defines the actual email content and which list of addresses to use, the other defines the list of addresses. This table join allows email the sender to select which list of email addresses to use.
An understanding of the database tables is generally useful. Even if only to give you a rough idea of the kind of information that is stored and used to produce emails.u
The first table is et_mailing. This table stores the actual content of the email that may be sent to everyone listed to receive it. The control over actual sending of this content and the number of times it is sent is not stored in this table. This table is only a way of bundling the content of the mailing.
Mailing lists are defined on the table et_mailing_lists This is the table that lists all the recipients of any particular top level table, storing general information about this mailing.
Mailing lists define a list of recipients. They can be a SQL statement that retrieves the list of recipients. A mailing must have a mailing list attached to it before it is sent. To attach this mailing list to a mailing, update mailing
Mailing lists can be selected from any SQL query, but this table provides a general table to store subscribers names and email addresses in. You can insert an email subscription form into any pages using the $buttons class
These string tokens will be replaced with recipient information.