email addresses of enabled members

Version 1
    select u.username, u.lastname, u.firstname,  
    from jivedw_user u  
    where userenabled=1;  


    This is another handy query for if you want to do something not-social like send a mail to all members

    If you concatenate in Excel to add on a semicolon to the end of the email address they cut/paste into Outlook well.