Home Code Pull the email domain from a string VBA Access visual basic

Pull the email domain from a string VBA Access visual basic

750
0

Right([HomeEmail],Len([HomeEmail])-InStr([HomeEmail],”@”))

If the field containing the emails has and null or empty strings in it make sure you set the criteria to ” Is Not Null And Not “” ” or else you will get the error: “Data type mismatch in criteria expression.

LEAVE A REPLY

Please enter your comment!
Please enter your name here