Problem with Generate Mailing List

[wampforum]

Hi folks,
hope someone can help as I have been nabngin my heda all morning on this! I am trying to create a list of user emails and name to import to mailchimp. I tried the generate mailing list option but it will not seperate data - just displays as one column regardless of linebreaks, commas anything.
Any I ran an SQL query that gave me the details fine but its only showing me 618 results - I have 1160 members on my site so why are they not showing on the generate mailing list or SQL results? I get the same issue if I run the query via phpadmin - usertable shows 1160 entries but only produces 6128 on query

The SQL I ran was:
SELECT email FROM user

Also anyway of pulling real names into the SQl query?

cheers

Brett

--------------- Added [DATE]1310482763[/DATE] at [TIME]1310482763[/TIME] ---------------

OK I have sorted things!

[stephen1976]

Do you know how to down loaded the emails address from vbulletin. I just the email address from my database CSV forexcell if you do could you tell me how, that would help me as I using phplist.

Have you looked at phplist! for yourself

[Badshah93]

Originally Posted by stephen1976

Do you know how to down loaded the emails address from vbulletin. I just the email address from my database CSV forexcell if you do could you tell me how, that would help me as I using phplist.

Have you looked at phplist! for yourself

Admincp -> Users -> Generate Mailing Lists

[stephen1976]

So how do i make that met these requirements

http://docs.phplist.com/ImportUsersInfo

Really need help with this i am sinking!!!

[Badshah93]

if you want list of email address seperated by comma then

go to Admincp -> Users -> Generate Mailing Lists

Text to separate addresses by:

,

and click on go

[stephen1976]

got that bit then how do i then save them into a compatable file.

[Badshah93]

i think you need to paste all email id which u got from generate mailing list (seperated by comma) in a txt file and then import it.

[wampforum]

I couldnt get the email addresse's seperate in the generate mailing list but did using the SQL query - then just copy and paste into excel

[stephen1976]

thanks that works as i spoted their mistake in the instructions, thanks for your help. going to take a while to import 50,000

[artificestudios]

Is it possible to get more than just the email address? I want member name as well?