: Simple Tool For Manage News letter and e-mail marketing campaigns
Software Used
: PHP, MySQL
Email Marketing Tool - Manage News letter and e-mail marketing campaigns
Two modules - Admin and User
Need Login to Access the Email Marketing Tool.
Adding E-mail id through CSV Files (bulk upload and add) and Manual Entry (one by one).
Display all E-mail id with search option (keyword search) and drop down search. You can also update email status as 1 without sending mail to user as well as delete email also.
Managing cronjob.
Reset E-mail status (back to 0 for sending mail) with specific option.
Adding Email message with FCK editor.
List out the email messages by Message Identifiers with edit options.
Display all email list with edit option.
Bulk emails delete option.
Find below some screenshots which will help to understand the working with this script.
This is for new user Register Page. Its a simple form with username and password. Within a couple of second you can create account. And also it need not any account verification.
2. Login Form:
This login page both Admin and User. User redirect to admin module or user module based on their user type. The default user type is 'user'.For this application only one admin.
User Module
In the User Module, user can only add list of emails and also see their added emails with option, how many emails sent by admin and still what are all the emails waiting for sending.
3. Add Email Id's:
Here two options
1. Upload CSV File.
2. Manually Add Email.
If user click Upload CSV File it shows File upload for uploading your emails. If user clicks Manually enter option, in this option you can enter email one by one.
4. View Email Id's:
User can view all emails added by only this user. Here provided option for viewing sending and usend emails.
Admin Module
Admin only have all rights to managing all emails. Admin also add emails and also send emails to user and delete emails and reset emails and adding email message.
4. View and Send All Email:
This page has many process.
1. Admin can view All Email id's.
2. Admin can send Email Message in All Email id's or List wise by select check box options.
3. Here two search available.Both search wont return any sent emails. Using keyword search you can search emails and using drop down search you can search emails.
4. Clicking 'Select All' and 'Clear All' button you can select or deselect emails.
5. Clicking 'Send Mail' button you can send mail to user. For this you need to select 'Message Identifier' for email message.
6. Clicking 'Change Email Status' button you can update email status as 1 (it denote the email sent) without sending mail to user.
7. Clicking 'Delete' button you can delete selected emails.
5. Managing Cronjob
In this page you can manage email list for automatically sending emails to user from cronjob. See below screen shot. This is screen of initial stage.
See below screen shot, this is screen for adding email list to cronjob for sending mail. For this you need to select message identifier also. Once clicking 'Add' button this combination will be stored in table with status as 'disable'.
Below screen shot for Activating your email list for sending mail from cronjob. From this you need to select any one item from drop down and click 'Activate' button.
Below screen shot for Disable your email list. From this you need to select any one item from drop down and click 'Disable' button.
6. Reset your emails status
In this screen you can reset emails by selecting email list. Here also two search option there. One is keyword search and another one is drop down search. After selecting needed emails then click 'Update' button, it update all selected emails status as 0. See below screen shot.
7. Add New Email Message
Admin can add new message. Here all fields are required. The message identifier should be unique for identifying email message. Here FCK editor is available for adding body of message.
8. Edit Email Message
Admin can edit email message one by one. This page show List of messages and edit link.
After clicking 'edit' link from previous screen shot it will allow to edit that message. Here except message identifier (read only) you can edit all fields.
9. Add, View and Edit List Name
This page has three processes.
1. Add List
2. View all list
3. Edit List
After Click 'Edit' link from above screen shot it will display list name for editing. See below screen shot.
10. Delete Email Id's
This page needs a text file for uploading emails. A bulk of emails uploaded from this text file and delete all uploaded emails. The deleted emails will stored in table with status deleted status 0. If you want we use same csv file for uploading emails.
