make name in one field the email name in another field

[tbcwarrior]

main_database form i have a field called coordinators
this field has a list of coordinators in a drop down box

and i also have a field called coordinatorsEmail

what i am trying to do is when the coordinators field has a name in it i want to tell the email field to input a certain email address

ie cordinator joebloggs
email address is joe@myemail.com

i have tried playing with if then and else if commands but not quite sure of the code to create

 

[FoFa]

Your biggest problem using your example, is where do you parse joebloggs to come up with joe? Adding the @MyEmail.com (if a static field, say for your company) is the easy part. Since (using your example) there is no delimiter between the joe and bloggs, how is it suppose to know to parse it there?

 

[rgreene]

I have the same question. I have a FName field and an LName field and I want to take the FName data put in a . (period) then the LName data with the static @email.com

Thanks,

Rick

 

[gemma-the-husky]

rgreene:

email = fname & "." & lname & "@email.com"

or are you after something more complex than this

 

[ansentry]

rgreene,

Have a look at the attached sample;