how to select all contact emails of customers in Cpanel

[lowhigh]

Hi all!

Please help me:
how to select all contact emails of customers in Cpanel?
I don't know the structure of Cpanel database

Thanks!

 

[cPanelTristan]

Hello lowhigh,

Do you mean the cPanel > Email Accounts area email addresses for all email addresses on a single cPanel account, or do you mean the contact email setup for each cPanel account holder?

If you mean the second, you can use WHM > Account Functions > Email All Users area to email all cPanel account holders who have setup a contact email.

Thanks!

 

[lowhigh]

Thanks Tristan!

I have known how to send notification to all emails of our customer. But we really need to export all these contacts to a file from Cpanel database!
Please help me!

 

[cPanelTristan]

There is not a database containing these contact emails. They are contained in /home/username/.contactemail location (where username is the cPanel username) and could be grabbed from that location.

 

[sawbuck]

There is a previous thread where I've attached a script you can run at the root prompt.

Have also attached it again here.

 

[lowhigh]

Many thanks to sawbuck& Tristan!

I have resolved my problem with your kindful help!