how to export users who agree to emails?

[Brandon Sheley]

hello,

how can I export a list of users who have agreed to user emails so I can import them to my mailchimp plugin?

Thanks
-Brandon

 

[Mike]

Just go to Email Users and "only generate a list of email addresses". It's actually the email and name tab separated so it can be put directly into MailChimp (IIRC) or can be pasted into something like Excel and exported as desired.

 

[Brandon Sheley]

sweet, thanks Mike

(Ps.. I was hoping it would be that easy but didn't see an option right away)

PPS.. thanks, worked prefect
now to just get the newsletter together

 

[Chimpie]

Is there a way to export just the email addresses?

I've copied and pasted my list into excel but it puts both the email address and username in one column. Or is there a way to paste it into two columns?

 

[Paul B]

Use the text to columns function, delimited on space.

 

[kevinchan]

Use the text to columns function, delimited on space.

Hi Brogan,

Could youo explain more details about this? Is it something related to excel?

Thank yoU!

 

[kevinchan]

Ah, i got it alreadt, thanks!

 

[Nusaint]

Hey Guys,

Tried doing this but not working for me. I get a blank page.

Any pointers?

 

[Paul B]

A blank page is sometimes due to a suppressed error. Edit the library/config.php file and add the following:

ini_set('display_errors', true);

 

[Nusaint]

A blank page is sometimes due to a suppressed error. Edit the library/config.php file and add the following:

ini_set('display_errors', true);

Thanks Brogan,

I have added that but nothing is happening. Where do I go to check the error?

Regards

 

[Nusaint]

Sorry man I spoke to soon. Fatal memory message

Thanks again

 

[Paul B]

See the FAQ here for how to potentially resolve that: https://xenforo.com/community/threads/frequently-asked-questions.5183/#post-282417

 

[viper357]

Use the text to columns function, delimited on space.

It's under the Data menu in Excel. (just putting this here because I keep forgetting how to do it.