Has anyone found an easy method to search CRM for phone numbers of the
National Do Not Call Registry? The first file I downloaded is 1.2 GB
of nothing but phone numbers. I need to go through and remove those
leads, opportunities, contacts etc.

Thanks.

Re: National Do Not Call Registry by MJ

MJ
Thu Dec 29 11:18:13 CST 2005

Do you want to remove them or mark them as not contactable by phone? Each of
those entities has an attribute (well, several, actually) to disable phone,
fax, etc. contact. Either way you've got a huge problem on your hands. I
know how to do it (having written this kind of scrub before), but I don't
have any code that can do it for you.


--
MJ Miller
Microsoft CRM Technical Lead

** The opinions and comments in this post are my own and in no way reflect
the opinions of Microsoft or the Microsoft CRM team. This posting is not an
offer of support, either immediate or ongoing, and no support is implied.
Some of the information posted may include non-supported workarounds and
code samples.



Re: National Do Not Call Registry by gwomick

gwomick
Thu Dec 29 12:15:36 CST 2005

I would like to remove them if they are older than 18 months, mark them
if they are newer than 18 months.