separate field

K

kc-mass

Very easy if names are all structured that way - which they are usually not
all that way.

txtEmailName = left(name,instr(name," ")-1 & "." & mid(name,Instr(name, " ")
+1 & "@AOL.COM"

Regards

Kevin
 
Top