Hey guys, I have a guy who was using some unknown software on his laptop that he no longer has admin right to that bollixed up his contacts in OL. So, he has ~7400 now and prolly only ~500 are valid. The issue with using tools of my choice to fix this are the few fields that contain odd characters, so I am trying to do it in excel. I found a macro to check dupes (the built in sort method crashes excel) but its removing some amount of contacts completely?
Anyone got a robust macro for excel that can remove duplicate records in large datasets? Thanks! jlc ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
