emailing - auto update of address book from .csv
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!