Kingmailer.com

Help on mail using MS SQL mailing.

Click the SQL button on KingMailer to enable SQL window.

MS SQL window

Click the spot to know more about it.

1	SQL enable control

2	Server login information

3	Server connectivity test

Click this 'Test' button to confirm the connectivity with the server.
KingMailer will try to contact the SQL Server and verify the username and password.
If the information provided is all correct, you will get success message.

4	List tables

Click the "Show all tables" button to list all the available tables on this database.
You can click on required table name to select it.
If the required table is listed, you can also stop further listing.

5	List fields

After selecting the table, you can click this "Show selected fields" button to list all the available fileds on this table.
You can select only the required fields by checking them.
Select only the fields which are required by you for filtering or personalization. If your server is in a remote place, this avoids loading unwanted data.
You should now click on the email field label where you have your emails. This is important. Because, KingMailer should know on which field you have your emails.
On selecting the email field, you will see the name appear on the right side text box. You can also manually enter the field on this text box.

6	Email field

Select the email field from the field list on the left of this text box or enter the email field name directly here.
KingMailer will search for emails only on this field.

7	Mailing status field

Status field name to store the result of each mailing.
You can create a field on your SQL database with minimum 50 alpha numeric characters for this purpose.
At the end of each mailing process, KingMailer will update the result in this field.

You can have your SQL in such a way that mailed records will not be listed again.
If you have a status field with the name 'm_MailStatus', you can have the SQL as below.

8	Update Query creater

After you enter the email field and status field, you can click this button to create the 'status update query'.
You can also directly create this query and enter it in the bottom text box. This button only helps you to make it easier.

Let's say your email field is m_email and your status field is m_MailStatus
The query will be as below...
UPDATE lh_tblMembers set m_MailStatus='{{result}}' where m_email='{{email}}'
Please note the parameters marked in RED. These will be replaced by the 'email' of the current record and its 'mailing report'.

You can also leave the status field empty. In this case, no update action will be taken.

9	Master Query

This is the main query which gets executed when you try to list the records or try to send emails.
You can have your own query here.
Selecting a the 'table' from the above table list and selecting the required email field will create the simple query automatically.
Only the text between 'SELECT' and 'FROM' on the SQL are affected when you select the above tables.
You should enter your own WHERE clause.
If you have a status field with the name 'm_MailStatus', you can have the SQL as below.
SELECT * FROM tablename WHERE not m_MailStatus='<ok>'
This will filter previously mailed records.

10	Update Query

This is an optional query. This will be executed at the end of every individual mailing process.
You can have an upate query here to update a status field on your database with the result of a mailing thread.
Use this field to filter the already mailed records.

Let's say your email field is m_email and your status field is m_MailStatus
The query will be as below...
UPDATE lh_tblMembers set m_MailStatus='{{result}}' where m_email='{{email}}'
Please note the parameters marked in RED. These will be replaced by the 'email' of the current record and its 'mailing report'.

If you leave this text box empty, no action will be taken at the end of each mailing.