Click to See Complete Forum and Search --> : question


lindawqu
July 13th, 2001, 05:14 PM
what is the better way to get "mary@hotmail.com" from the following?

"contact me" <mary@hotmail.com>

Mary

cksiow
July 13th, 2001, 07:02 PM
use inStr to get the pos of "<" & ">" and then use mid to extract the address.


HTH

cksiow
http://vblib.virtualave.net - share our codes