Export User data

[jim doodle]

Is there a simple way to export the user data, reason being i am setting up an owners club and require all users to add their correct postal address, which i then need to export and mail merge with a franking system.

Ideally i want a simple system which the admin can use.

anyone got any ideas?

--------------- Added 1250464978 at 1250464978 ---------------

I am not sure i can do this in the normal backend an di can;t find any advanced export facilities as addons.

what about a custom SQL query?

SELECT username FROM user WHERE usergroupid='9';

anyone knows the table/names of the custom fields in the database?

--------------- Added 1250470346 at 1250470346 ---------------

To anwer my own question:

SELECT userid, field6, field7, field11, field8, field12 FROM userfield WHERE userid IN (SELECT userid FROM user WHERE usergroupid='9');

where field6 - field 12 are address fields and usergroup 9 is my desired usergroup to pull from