Database Help

[WinJStar]

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?

[spaceboy761]

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.

[Niccivan]

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)

[spaceboy761]

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!

[Niccivan]

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

[WinJStar]

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

[WinJStar]

Greg -

Email sent.

[Niccivan]

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)

[WinJStar]

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.

[Niccivan]

Even better