User Tag List

Page 1 of 2 12 Last
Results 1 to 10 of 17

Database Help

This is a discussion on Database Help within the Luvin's Social Lounge forums, part of the Luvin Poker's Social Lounge category; Okay, so it worked when Greg asked for help.... I have a list of about 20,000 Email addresses of poker ...

  1. #1
    WinJStar's Avatar
    WinJStar is offline Owner
    Mom says if I can't say something nice, don't say anything at all.
     
    Question
     

    Join Date
    Oct 2006
    Gender
    Female
    Location
    Las Vegas, Nevada
    Country:
    United States
    Posts
    24,008
    Chips
    17,551
    Stars
    23,357
    Blog Entries
    12

    Database Help

    Okay, so it worked when Greg asked for help....

    I have a list of about 20,000 Email addresses of poker players, all comma separated. I am doing a gigantic promo mailer for our big freeroll. Um, lets just say I got this list from a friend Anyway, I think there are tons of duplicates and spam mail is already so annoying I don't want to send the same person 4 of the same thing. Any ideas how to delete duplicates using Excel or a mail program?
    Go Team SWS*! Follow us on Twitter and Facebook!

    Awards Showcase


  2. #2
    spaceboy761's Avatar
    spaceboy761 is offline Senior Member
    This user has no status.
     
    ----
     

    Join Date
    Dec 2006
    Location
    Long Island
    Posts
    4,179
    Chips
    4,183
    Stars
    4,144
    I can solve that in about ten seconds. Just PM me for my e-mail here at work and consider it done. If I fail it everything else in this business, I can always make a living as a first-class data monkey.

    I like black pugs and I cannot lie...

  3. #3
    Niccivan's Avatar
    Niccivan is online now Potty Mouth Mod
    Today is a good day..... must. think. happy. thoughts.
     
    Angelic
     

    Join Date
    Oct 2006
    Gender
    Female
    Location
    Niceville, FL
    Posts
    14,876
    Chips
    13,908
    Stars
    14,237
    Blog Entries
    10
    Where was all the comma separated emails when I did this about 4 months ago (although, importing the file from excel into email wasn't hard. Detecting duplicates was a pain in the ass)
    "For Those That Have Fought For It, Freedom Has A Meaning The Protected Will Never Know"

  4. #4
    spaceboy761's Avatar
    spaceboy761 is offline Senior Member
    This user has no status.
     
    ----
     

    Join Date
    Dec 2006
    Location
    Long Island
    Posts
    4,179
    Chips
    4,183
    Stars
    4,144
    Detecting duplicates is easy enough if you do it in Excel before exporting to Access or whatever other format you need. Yeah for binary integer variables!

    I like black pugs and I cannot lie...

  5. #5
    Niccivan's Avatar
    Niccivan is online now Potty Mouth Mod
    Today is a good day..... must. think. happy. thoughts.
     
    Angelic
     

    Join Date
    Oct 2006
    Gender
    Female
    Location
    Niceville, FL
    Posts
    14,876
    Chips
    13,908
    Stars
    14,237
    Blog Entries
    10
    Yeah, I love excel (when it agrees with me and doesn't give me # errors). I need to look into that particular format, cause I obviously failed to see it when I did this for another cause a little while ago.

    other than that....piece of cake except for the fact that yahoo wouldn't let me import more than 5,000 at a time, and then I couldn't email but 50 at a time without it going to spam So, it was just a tad but time consuming
    "For Those That Have Fought For It, Freedom Has A Meaning The Protected Will Never Know"

  6. #6
    WinJStar's Avatar
    WinJStar is offline Owner
    Mom says if I can't say something nice, don't say anything at all.
     
    Question
     

    Join Date
    Oct 2006
    Gender
    Female
    Location
    Las Vegas, Nevada
    Country:
    United States
    Posts
    24,008
    Chips
    17,551
    Stars
    23,357
    Blog Entries
    12
    Nicci, it is that list plus about 5000 more. Some people got hit up several several times and I had people threatening to call the spam cops..... haha
    Go Team SWS*! Follow us on Twitter and Facebook!

    Awards Showcase


  7. #7
    WinJStar's Avatar
    WinJStar is offline Owner
    Mom says if I can't say something nice, don't say anything at all.
     
    Question
     

    Join Date
    Oct 2006
    Gender
    Female
    Location
    Las Vegas, Nevada
    Country:
    United States
    Posts
    24,008
    Chips
    17,551
    Stars
    23,357
    Blog Entries
    12
    Greg -

    Email sent.
    Go Team SWS*! Follow us on Twitter and Facebook!

    Awards Showcase


  8. #8
    Niccivan's Avatar
    Niccivan is online now Potty Mouth Mod
    Today is a good day..... must. think. happy. thoughts.
     
    Angelic
     

    Join Date
    Oct 2006
    Gender
    Female
    Location
    Niceville, FL
    Posts
    14,876
    Chips
    13,908
    Stars
    14,237
    Blog Entries
    10
    Yeah.....sorry. I did my best to delete duplicates. I should have alphabetized the list before I imported 5000 at a time, because once I deleted the first 5000 for the next 5000, if there was a repeat it wouldn't have remembered. Oh well, kudos to Greg for knowing how to get it done. Hopefully he can send them to you 50 at a time, too (hint hint Greg)
    "For Those That Have Fought For It, Freedom Has A Meaning The Protected Will Never Know"

  9. #9
    WinJStar's Avatar
    WinJStar is offline Owner
    Mom says if I can't say something nice, don't say anything at all.
     
    Question
     

    Join Date
    Oct 2006
    Gender
    Female
    Location
    Las Vegas, Nevada
    Country:
    United States
    Posts
    24,008
    Chips
    17,551
    Stars
    23,357
    Blog Entries
    12
    No, no, no, no.... I need them all together exactly how I sent them to him. I worked hard getting it to where it is. Haha. We are going pro and sending them out from a real mail server so I don't need to separate them. They just need to be in csv format.
    Go Team SWS*! Follow us on Twitter and Facebook!

    Awards Showcase


  10. #10
    Niccivan's Avatar
    Niccivan is online now Potty Mouth Mod
    Today is a good day..... must. think. happy. thoughts.
     
    Angelic
     

    Join Date
    Oct 2006
    Gender
    Female
    Location
    Niceville, FL
    Posts
    14,876
    Chips
    13,908
    Stars
    14,237
    Blog Entries
    10
    Even better
    "For Those That Have Fought For It, Freedom Has A Meaning The Protected Will Never Know"

Page 1 of 2 12 Last

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •