what is the better way to get "[email protected]" from the following?
"contact me" <[email protected]>
Mary
Printable View
what is the better way to get "[email protected]" from the following?
"contact me" <[email protected]>
Mary
use inStr to get the pos of "<" & ">" and then use mid to extract the address.
HTH
cksiow
http://vblib.virtualave.net - share our codes