Please help, sending newsletter batch email

[reddymade]

I want to create a new function to send the emails to a batch.

Can you please tell me how i can store all the email address, i am using php 5.0 with mysql

In the database table can i store all the email addresses.

Please if you have any code for doing the above function, can you provide.

Thank you very much.

[niroshan]

Hi,
here i have wrote a small application that handle your requirement. It basically fetch details from a database and display the information so u can select the customers u wish to send the mail. this also has a searching feature. This is the sql for create the table,

CREATE TABLE customer (
'idint(20) NOT NULL default '0',titlevarchar(5) NOT NULL default 'NA',FIRSTvarchar(50) NOT NULL default 'NA',middlevarchar(50) NOT NULL default 'NA',lastvarchar(50) NOT NULL default 'NA',suffixvarchar(5) NOT NULL default 'NA',emailvarchar(50) NOT NULL default 'NA',teleHomevarchar(15) NOT NULL default 'NA',teleOfficevarchar(15) NOT NULL default 'NA',zipvarchar(10) NOT NULL default 'NA',countryvarchar(30) NOT NULL default 'NA',addressvarchar(150) NOT NULL default 'NA',webSitevarchar(70) NOT NULL default 'NA',faxvarchar(15) NOT NULL default 'NA',typeOfBussinessvarchar(50) NOT NULL default 'NA',designationvarchar(50) NOT NULL default 'NA',companyNamevarchar(100) NOT NULL default 'NA',cityvarchar(30) NOT NULL default 'NA',provincevarchar(50) NOT NULL default 'NA',
PRIMARY KEY (id`)) TYPE=MyISAM;

just edit the header.php file. header.php file will have the database name, username, password and the host name.

In this application you can uncheck the customers that u do not wish to send the mails.

I wrote this sample code just to give u an idea. so please to go through this code and try to undestand how to do it instead use the same thing 🙂.This is a basic code try to improve it from u r self ok .. 🙂
good luck