Export CB users database (xxx_comprofiler) to Excel including email address

There are a couple of different ways I can export my CB 1.9.1 database, either via SQL to Excel or via the export function in phpMyAdmin. The problem is that, although I am able to export almost all fields, I am unable to export the email address to an excel file...someone once told me that since it's a system file, I can't get it via export.

My client would like a spreadsheet of all users, including custom fields AND of course, email address. How can I get the email address field to download? Thanks for your help, Tim

nettop wrote: There are a couple of different ways I can export my CB 1.9.1 database, either via SQL to Excel or via the export function in phpMyAdmin. The problem is that, although I am able to export almost all fields, I am unable to export the email address to an excel file...someone once told me that since it's a system file, I can't get it via export.

My client would like a spreadsheet of all users, including custom fields AND of course, email address. How can I get the email address field to download? Thanks for your help, Tim

Do a join on comprofiler and users table and export the result.