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!