Can I import email addresses for my Newsletter etc

[Guest]

Hello all,

 

I have a fairly newish shop and am looking at using the newsletter side of things. I have a mailing list that I have been using for some time but want to get the addresses into osCommerce for the Newsletter. I only have the email address stored in another database at the moment.

 

anything I can do ?

 

cheers,

 

Adam

[DougB]

First unload the structure of the table from MYSQL (using MYSQL ADMIN)that has the addresses, then extract your email addresses from your current database into Excel , then change the structure in Excel to match that required by the MYSQL table and save as .csv. Finally go into MYSQLADMIN and import the data from the csv file. Voila! :D