how to send to 20,000 emails you have in a database?

Discussion in 'General Business' started by toycat, Oct 23, 2009.

  1. #1
    I have 20,000 legitimately gained emails in my database in a column of a table, how do i get that into an emailer?

    Once again, all the emails were given willingly, by members of my site
     
    toycat, Oct 23, 2009 IP
  2. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #2
    how abt getting a vps / server and trying with email list ? shared hosting will suspend u for sure :D
     
    chandan123, Oct 23, 2009 IP
  3. toycat

    toycat Well-Known Member

    Messages:
    2,304
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    150
    #3
    I get unlimited everything (except 50 DBs and emails) on shared so :D
     
    toycat, Oct 23, 2009 IP
  4. Nerv

    Nerv Active Member

    Messages:
    568
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    70
    #4
    It's not about bandwidth or space on your server. Sending so many emails will use a lot of cpu on your server machine. I suggest you should ask them first ;)
     
    Nerv, Oct 23, 2009 IP
  5. theapparatus

    theapparatus Peon

    Messages:
    2,925
    Likes Received:
    119
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I think the poster is asking how to export out the addresses and import them into a mailer. I don't recall seeing anything about what type of hosting they need.

    What hosting platform are you using? ie CPanel, Direct Admin, etc.

    Within that platform, are any mailers available to be used?

    Did your host have any suggestions? Have to admit I would clear it with them first as well. Also many hosts have limits in place on how many emails you can send at one time or within a certain time period. That's a concern.
     
    theapparatus, Oct 23, 2009 IP
  6. bigbody300

    bigbody300 Well-Known Member

    Messages:
    1,283
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    130
    #6
    I would like to know as well - using CPANEL
     
    bigbody300, Oct 23, 2009 IP
  7. jNorth

    jNorth Peon

    Messages:
    202
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #7
    You can get them out of the db in CPANEL - my sql Admin

    select 'COLUMN' FROM 'TABLE'

    export to csv or excel or whatever.

    I can send 20000 on one of my shared hosts, but it would take about 32 hours. My system reads direct from DB, so no exporting is required
     
    jNorth, Oct 23, 2009 IP
  8. toycat

    toycat Well-Known Member

    Messages:
    2,304
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    150
    #8
    when its in excel what do you do with it?
     
    toycat, Oct 23, 2009 IP
  9. mentos

    mentos Prominent Member

    Messages:
    15,280
    Likes Received:
    473
    Best Answers:
    0
    Trophy Points:
    330
    #9
    The best way is import it into 3rd part auto responder such as aweber.
    Then you can easily sent using aweber.
    Sending via hosting is no recommended due to many downside such as IP blacklist.
     
    mentos, Oct 23, 2009 IP