Zen Cart Logo
Forums / All Other Contributions/Addons / Exporting email addresses - Newsletter Subscribe mod

Exporting email addresses - Newsletter Subscribe mod

Locked

Views: 1,007

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
18 Feb 2010, 3:15 PM
#1
meltdown avatar

meltdown

Totally Zenned

Join Date:
Jun 2006
Location:
My family and I live in Brighton, England
Posts:
947
Plugin Contributions:
0

Exporting email addresses - Newsletter Subscribe mod

I have the Newsletter Subscribe mod installed. In this case, I've found that the proper table to export email addresses is: subscribers, and so I've found that to generate a list of email addresses from the phpmyamin database, I need just run this SQL query:

SELECT email_address FROM subscribers

Or if that throws an error indicating that there is no such table, try adding the prefix:

SELECT email_address FROM zen_subscribers

When the list of emails appears, scroll to the bottom of that page and click the Export button. The next page will allow you to select which format to export the addresses in. I generally select CSV and then leave the "Fields Enclosed By" option blank. This will generate a simple alphabetical list of email addresses.

Good luck!

2 Apr 2010, 4:54 PM
#2
sunflowertami avatar

sunflowertami

Zen Follower

Join Date:
Jun 2008
Posts:
267
Plugin Contributions:
0

Re: Exporting email addresses - Newsletter Subscribe mod

I have the export email addresses mod as well as the newsletter subscriber mod. Whenever an email bounces back, I delete it from the subscriber mod however I've noticed that when I export the email from the export email addresses mod, it still carries the email address I deleted.

It seems the export email is using a different table? How can I change the code around so that it would export from the correct table (where I have made changes on?) Thanks!