separate field

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I have a field which contains first and last name. I want to convert it to
an email address.

For example: Bob Jones
I want to have (e-mail address removed)
 
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
 
Back
Top