I am having trouble with this...
----------------------
Your file should be in CSV format. Ensure that each line of the CSV file is in the following format: email_address<tab>is_active. For example,
[email protected]<tab>true where <tab> is a \t (tab key)
----------------------
What I have done so far
Excel -
[email protected] (pressed tab key - goes to new column, and the email address has the blue line under it...)
True (in next column)
Then tired to upload - with no joy - Have a green tick and says - 0 emails have been successfully imported
------------------------------------------------
*Have also tired, several other ways to add a new file in the newsletter module... ie: export and used my files like the export then import in... also changed it CSV format...
----
Also looked at the Database - anyone with a good script say i can try to insert emails (as i am not sure about the [NewsLetterSubscriptionID] )
---
INSERT TO [MyDatabase].[dbo].[Nop_NewsLetterSubscription]
([Email],[Active],[CreatedOn])
VALUES
(
[email protected],1,2010-10-15 11:46:41.437)
GO
---
Any help would be great...