I went to Control Panel >> Membership >> Member Management and opened the Advanced Search Options. I clicked one of the boxes in Member Group, then clicked "Submit".

The Search Results gave all of the members that I expected to see. Under All Members or Selected Members? I selected "All Members in Search", and under Action I selected "Email".

Under Available Email Options: I selected Export List of Addresses, then clicked "Generate Emails". Under Address Export Options: I selected Show List in Browser Window, and under Output Format: I chose One Address per Line, then clicked on "Create Email List".

I received the following message:
Quote
SELECT t2.USER_REAL_EMAIL FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3 WHERE t1.USER_ID <> '1' AND t1.USER_ID = t2.USER_ID AND t1.USER_ID = t3.USER_ID AND t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' and t4.GROUP_ID IN (6)GROUP BY t1.USER_ID ORDER BY t1.USER_ID ASC

Unknown table 't4' in where clause
How do I get an email list of all of my members in a specific group?

Last edited by mjuby; 11/09/2006 3:29 PM.