Personally, I would visit Quad/Direct Mailing at https://www.qg.com/productsservices/directmarketing/subdirectmarketing.asp or perhaps QuadData Solutions at http://www.quaddatasolutions.com, but of course the disclaimer would be the domain of my email address and my ~13 years here at the world's largest privately held printer. :) If you don't want to outsource, have you considered using the Regular Expressions available in 10g? I didn't see a mention of what version of Oracle you're using... Rich -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of stv Sent: Mon 10/02/2006 17:49 To: oracle-l@xxxxxxxxxxxxx Subject: Managing large physical mailings ... Hi all, We're a non-profit that does quite a bit of physical mailings: newsletter, catalogs, etc. There are three data sources and there's quite a bit of overlap. It'll take some time to clean that mess up ... meanwhile we'll have to work with what we have. I'm new here and I have a few weeks before the next "big" mailing goes out (only 20,000). I've never dealt with bulk snail mailing before, but it seems to me the problem of isolating duplicates from multiple data sources was solved many, many, many years ago. Do y'all do this much yourself? Or do you outsource it? If you do it yourself, what advice would you have for a newbie in this area? [snip] -- //www.freelists.org/webpage/oracle-l