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

Pull the email domain from a string VBA Access visual basic

1559
0

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

If the field containing the emails has 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.

Previous articleModularity Lite WordPress theme change table row background color light blue
Next articleRecover exchange mailbox for deleted user active directory

LEAVE A REPLY

Please enter your comment!
Please enter your name here