henryzhang

Hi, not sure where this thread should go, but hear me out.

I posted yesterday requesting help for an automated emailing system.

Further investigation has lead to me discovering that the problem isnt really with the emailing program, but the way our database works.

Our database contains our customers info (over 20,000 customers, constantly updated everyday), and we can offload their info as a .csv file. What I need is for this .csv file to be imported into an emailing program so that the address book is updated everyday, automatically. After this, I need the email program to recognise a parameter within the .csv file ('email type') and thereby send the correct email to the customer. The scheduling of the emailing is possible in many programs, but the actual importing of the .csv file is still manual.

I was wondering if anyone knows how to make the importing of the file automatic, perhaps program it so that it does it everyday, maybe one hour before the email schedule.

Is this possible with php/java/c++ etc? Can it be used in collaboration with an existing emailing program, such as Outlook or Mach5? I don't really know about coding myself, so any help is greatly appreciated!

Regards,

Henry
www.mobal.com

nnxion

Yes that certainly is possible. One can do this with C, C++, C#, Java or many others. A .CVS is a comma separated file (CVS = Comma Separated Value file), so can easily be tokenised.

The problem is working with another e-mail program, I do not know how such programs work, and I don't think there is an open standard on how they work.

Are you willing to pay for it or are you searching for volunteers? Or are you here to learn it yourself?

__________________
"Employ your time in improving yourself by other men's writings, so that you shall gain easily what others have labored hard for."
-- Socrates

henryzhang

oh right. Well if you are able to do it, then please quote us, and we'll see if its within our budget.

The basic specs are:

Sending different emails to customers with certain parameters; obviously we write the emails, there are about 10 different ones.

Our system can offload a .csv file for customers with the required parameters.

We need a program that automatically updates this .csv into the 'address book' and sends the required email to customers.

We do not want a customer to get the same email twice.

Regards,

Henry

Ooble

I would personally suggest you incorporate the emailing into your current application, rather than relying on a third-party email client.

__________________
Me :: You :: Them