As an example, I am trying to identify individuals who are not using their company email addresses in profiles from a particular vendor.
I am able to pull the list of domains by using this expression:
Domain: Right(,Len([Email])-InStr([Email],"@"))
but am not sure how I would also tell it to show me everyone including individuals who have left the email field blank.
Can someone help??
I am able to pull the list of domains by using this expression:
Domain: Right(,Len([Email])-InStr([Email],"@"))
but am not sure how I would also tell it to show me everyone including individuals who have left the email field blank.
Can someone help??