Emails

[Crilen007]

I have a list of emails that was taken from a database.

We sent out a mailout to all of the emails and all the ones that were capitals got rejected.

What I need is to detect which ones are capitals, and separate those so I can change the case and resend.

Is there a way to detect if the last two characters are capital?

Thank you!

 

[pbaldy]

That's odd; in my experience email addresses are not case sensitive. In any case, see if the LCase function helps you force them to lower case.

 

[Crilen007]

Yea, I know how to convert them to lower case, but what I'm trying to do is detect the upper case ones to filter them out.

 

[pbaldy]

I guess if you want to go through the extra work of "separate those so I can change the case and resend" it's up to you. I would just fix/send them in one shot. I've never needed to bother with it, but I know using Option Compare Binary in a module will do case sensitive tests, or you can use the Chr function to see what range an individual character falls in, which will tell you if it's upper or lower case.

 

[Crilen007]

Thanks I used the asc value between and that worked great.