Question:
How do I migrate existing members to a mailing list that I have created?
Answer:
There’s no built in method for this but you can quickly and easily create a temporary page template that exports none pending members and then paste that data into the batch subscribe field in the mailing list module.
Create a template with the following code:
{exp:query sql="select email from exp_members where authcode='' order by email asc"}
{email}{/exp:query}
...and copy and paste the out put of the page from your browser into the mailing list module batch subscribe field. :)
Job done.
Best Practice: Protect this code snippet from others by modifying the templates access restrictions to prevent access by anyone other than SuperAdmins. You don’t want Google to index this page!
Export as .csv:
If you use an external email marketing application like Constant Contact or Mail Chimp and want to upload your mailing list, you can just add a semicolon like so:
{exp:query sql="select email from exp_members where authcode='' order by email asc"}
{email};{/exp:query}
Then save the browser output as a *.csv file. Make sure you change the file type in ‘Save As’ to “All Files’.
Category:Mailing List Category:Exporting Category:Import Category:Members