Thread

list_id   list_name   list_title   list_template

2   news   JDCC News   {message_text} To remove your email from this mailing list, click here: {if html_email}{unsubscribe_url}{/if} {if plain_email}{unsubscribe_url}{/if}

3   onetimenews   JDCC News Alert   {message_text} To remove your email from the “{mailing_list}” mailing list, click here: {if html_email}{unsubscribe_url}{/if} {if plain_email}{unsubscribe_url}{/if}

4   test   Test Email   {message_text}

To remove your email from the “{mailing_list}” mailing list,
click here: {if html_email}{unsubscribe_url}{/if} {if plain_email}{unsubscribe_url}{/if}

5   interpreters   Interpreters Referral List   {message_text} To remove your email from the “{mailing_list}” mailing list, click here: {if html_email}{unsubscribe_url}{/if} {if plain_email}{unsubscribe_url}{/if}

11   actmedia1   actmedia test   {message_text} To remove your email from the “{mailing_list}” mailing list, click here: {if html_email}{unsubscribe_url}{/if} {if plain_email}{unsubscribe_url}{/if}

The list I had in mind was ID #2.

Very good. Now repeat the procedure with this line of code:

SELECT email FROM exp_mailing_list WHERE list_id = "2"

That should result in a list of all your subscribers.

Got it, thanks! I get 5 pages… any way to get it all in one page, or need to copy & paste text manually from each page to excel?

You can run the same query using the Query module as well. Create a template just as Lisa suggested above, and put in it nothing but

{exp:query sql="SELECT email FROM exp_mailing_list WHERE list_id = '2' ORDER BY email ASC"} 
{email}
 
{/exp:query}

Best to copy & paste the code to get quotes and everything correct. Then visit this template in your browser by going to htto://example.com/index.php/site/mailinglist_export or whatever group and template you used. Makes sense?

Followed instructions. When I type in browser http://jdcc.org/index.php/site/mailinglist_export, I get the front page jdcc.org

What am I doing wrong?

You actually named your template email_export, not mailinglist_export. You can find it here (Remove template as soon as you’re done!)

I’ve taken the liberty to go through your text file and weed out any duplicates. There were 8. For privacy reasons, I’ll let you have the file via email.