private Function EmailStr(EmailName As String) As Boolean Dim ipart As Integer Dim lpart As Integer dim Length As Integer Dim isVaild As Boolean Dim sEmail As String If Len(Trim(EmailName) <= 0) Then EmailStr= False sEmail = Trim(EmailName) ipart = InStr(sEmail, "@") lpart = InStr(ipart + 1, sEmail, ".") Length = Len(Trim(Mid(sEmail, lpart + 1, 3))) If ipart <= 0 Or lpart <= 0 Then isVaild = False ElseIf Length < 3 Then isVaild = False ElseIf ipart = 1 Then isVaild = False ElseIf lpart = Len(sEmail) Then isVaild = False Else isVaild = True End If EmailStr= isVaild End Function
Dim ipart As Integer
Dim lpart As Integer
dim Length As Integer
Dim isVaild As Boolean
Dim sEmail As String
If Len(Trim(EmailName) <= 0) Then EmailStr= False
sEmail = Trim(EmailName)
ipart = InStr(sEmail, "@")
lpart = InStr(ipart + 1, sEmail, ".") Length = Len(Trim(Mid(sEmail, lpart + 1, 3)))
If ipart <= 0 Or lpart <= 0 Then
isVaild = False
ElseIf Length < 3 Then
isVaild = False
ElseIf ipart = 1 Then
isVaild = False
ElseIf lpart = Len(sEmail) Then
isVaild = False
Else
isVaild = True
End If
EmailStr= isVaild
End Function