Email adresses in VB forum?

Discussion in 'vBulletin' started by Taliban, Feb 8, 2008.

  1. #1
    Is there anyways to collect all emails of all users of forum?????

    there is some prob in my forum and can't send mass mails? how can i take all email adresses to send them mail from hotmail or yahoo?
     
    Taliban, Feb 8, 2008 IP
  2. peter_anderson

    peter_anderson Notable Member

    Messages:
    3,382
    Likes Received:
    152
    Best Answers:
    0
    Trophy Points:
    240
    #2
    How is your Mass Email not working? Have you tried?
     
    peter_anderson, Feb 8, 2008 IP
  3. Police

    Police Banned

    Messages:
    33
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I don't think we can extract email addresses from vb forum.
    Did you check vborg?
     
    Police, Feb 8, 2008 IP
  4. Taliban

    Taliban Peon

    Messages:
    267
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #4
    transfering servers came up with this prob..........it says email has been sent but it does not go to emails don't know prob
     
    Taliban, Feb 8, 2008 IP
  5. Shadab

    Shadab Peon

    Messages:
    376
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #5
    PHPMyAdmin -> Select your vBulletin's DB -> "SQL" Tab

    SELECT email
    FROM `user`
    LIMIT 0, 1110
    Code (markup):
    (I have 1110 users in my vBulletin DB so i used the number 1110 in the query above.
    Change it to any number greater than the no. of users in your vBulletin DB)


    Scroll down, select the "Check All" option.
    Then export the data by clicking the "Export" ( b_tblexport.png ) button.

    Suggested settings :

    Export Type : CSV

    Additional Options :
    "Save as file" : Put a tick/check
    "Compression" : None

    [GO]


    Hope this helps. :)
     
    Shadab, Feb 8, 2008 IP
  6. Qryztufre

    Qryztufre Prominent Member

    Messages:
    6,071
    Likes Received:
    491
    Best Answers:
    0
    Trophy Points:
    300
    #6
    ACP > Users > Generate Mailing List

    Select all usergroups, submit.
     
    Qryztufre, Feb 9, 2008 IP
  7. Shadab

    Shadab Peon

    Messages:
    376
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Oops... I never noticed that option in vB.

    Learned something new today! :)
    Thanks.
     
    Shadab, Feb 9, 2008 IP
  8. Qryztufre

    Qryztufre Prominent Member

    Messages:
    6,071
    Likes Received:
    491
    Best Answers:
    0
    Trophy Points:
    300
    #8
    Had I not just needed it myself I may have not known or forgotten it myself :D
     
    Qryztufre, Feb 10, 2008 IP
  9. Taliban

    Taliban Peon

    Messages:
    267
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #9
    woow nice thank u soo much :)
     
    Taliban, Feb 10, 2008 IP