separate field

[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 [email protected]

 

[KARL DEWEY]

MyE-mail: [FirstName] & "." & [LastName] & "@" & [Domain]

 

[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