The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

how to select all contact emails of customers in Cpanel

Discussion in 'E-mail Discussions' started by lowhigh, Sep 7, 2011.

  1. lowhigh

    lowhigh Active Member

    Joined:
    Jun 25, 2011
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    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!
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    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!
     
  3. lowhigh

    lowhigh Active Member

    Joined:
    Jun 25, 2011
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    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!
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    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.
     
  5. sawbuck

    sawbuck Well-Known Member

    Joined:
    Jan 18, 2004
    Messages:
    1,367
    Likes Received:
    5
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    There is a previous thread where I've attached a script you can run at the root prompt.

    Have also attached it again here.
     

    Attached Files:

  6. lowhigh

    lowhigh Active Member

    Joined:
    Jun 25, 2011
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    Many thanks to sawbuck& Tristan!

    I have resolved my problem with your kindful help!
     
Loading...

Share This Page