Compare an email address to a list of Names

[s2jrchoi]

All,

I am trying to see if an email address matches with a list of names in a worksheet. If so, it would proceed with code. For example, I have an email address '[email protected]' that we get through an input box and in the list, we find John Middlesburg. Since it is obvious that John Middlesburg is [email protected], how can I get it to go on through? Is there a way to do this?

Thank you in advance for your help.

[s2jrchoi]

I just put this together but found a couple of issues with it. For example, it doesn't seem like it works if the cases are off and it definitely can't compare email addresses to the list of names in the worksheet. The only thing I found that works is if you type in Middle (from the example in the 1st post), then it will exit the for loop and give you an integer other than 0. Please let me know if you have any advice on how to improve this code. Thank you!

Please Login or Register  to view this content.

[Leith Ross]

Hello s2jrchoi,

You could shorten the loop code to this...

Please Login or Register  to view this content.

Another method would be to use the Like operator...

Please Login or Register  to view this content.

[s2jrchoi]

Hey Leith,

I appreciate your help with this however the code to compare the strings will not work if an email address like "[email protected]" is provided. Is there a way to show that [email protected] is basically the same person as John Middlesburg?

Thank you!

[Leith Ross]

Hello s2jrchoi,

I would need to see a copy of your workbook. Email addresses can vary greatly and the more samples there are available to test the code with, the better.