database wash

[grumpydasmurf]

I have multiple databases. I am planning a mass mailing coming up soon. What I need to do is wash the list so I don't send multiple messages to the same person.

Advice?

[Rich]

So essentially you want to take each name and check through the database to see if it's duplicated? What kind of database are we talking about - mysql, access, outlook, excel?

[grumpydasmurf]

You got it Rich.

It's exell but all spreadsheets can be converted via CSV.

Convert to CSV. IMport into MySQL. Run a PHP script that washes the data. Export back to CSV. Done. Why didn't I think of that sooner?

[Rich]

If you take it into excel you could Sort>Data>by column A or whatever... then you would just have to look for duplicate names next to one another. Little more work.. haha.