E-Commerce Bulk Mailing System

Bulk mailing can be done using the customers, orders, affiliates and projects table.

Mailing Form

On this page, you can send mail to your customers, affiliates or suppliers. This can be used for sending out newsletters to all customers, or it can even be used to simply remail an order confirmation.

Form Fields

Email: This field is set to the reply email address that will be used in your email, ie. if a customer receives your email and decides to reply to it, their reply will be sent to this email address.

Name: This Field represents the name of the Person/Company from whom the mail is being sent, This will display as the From Name in your customer's mailing system.

Subject: This Field represents the subject of the email.

Type: This field represents the type of mailing interface that will be used to send the email. In most cases this should be left as is.

Email Format: This field represents the format of your email. If your email contains HTML then set this value to "HTML". If it is plain text, set it to "TEXT"

Table Name: This field represents the name of the table from which you will be retrieving your customers details. It can be set to "CUSTOMERS", "ORDERS", "AFFILIATES", "SUPPLIERS".

File Name: This field represents the name of your mailing template that you will be using to format your email. If you are not using a template, you should leave this field empty.

Attachment: This field represents the physical path to your attachment file, eg. c:\attachments\attachment.txt. If you do not want to attach any files to your email you can leave this field blank.

Merge with database: If your template needs to access certain fields from the database, eg. if you are remailing an order confirmation, then this needs to be set to "Yes". Otherwise, you should set this to no.

Message: If you are not using a template to format your email, you can enter your text into this field. If you are using a template then this field should be left empty.


Example - Re-Mailing a customer's order confirmation:

1. Set the Email field to "orders@yoursite.com"
2. Set the Name field to "Your business"
3. Set the Subject field to "Order Confirmation"
4. Leave the type field empty
5. Set the Email Format field to "HTML"
6. Set the Table Name field to "ORDERS"
7. Set the File Name field to "tmp_customeremail.htm"
8. Leave the Attachment field empty
9. Set the Merge with Database field to "Yes"
10. Leave the Message field empty
11. Click Continue
12. You will be transferred to a list of orders. Select the orders that you would like to re-mail
13. Click the "Mail Selected Records" button at the bottom of the Page

(Back to E-Commerce Online Store Features)