VBA - Recognize typos in email domain
I'm working on a VBA script that is to work through an extensive list of
email addresses and flag the ones that are suspected of being wrong.
I'd like to refine the routine by adding a function that would spot typos
in common domain names such as gmail, hotmail, msn, skynet, etc. I'll have
a list of these common display names in an array.
The string function would see if the inputted string looks similar but is
not the same as an element in the array, and return true as boolean if it
is the case.
Idea is to spot erroneous entries such as: homtail, mns, slynet, hotmal,
yahooo, etc.
Not looking for a script per se, looking for inspiration of how to tackle
this problem...
No comments:
Post a Comment