I have a FirstName field and a LastName field. From it I want to create an automated field called EmailAddress. The email address is First Initial Last Name, so John Doe is [email protected]. I know how to string together the parts but don't know how to pull that first initial. Could anyone lend a hand? Thanks kindly!

Take a look at the LEFT(FirstName;1) function. That will pick off the 1st letter.

I have a FirstName field and a LastName field. From it I want to create an automated field called EmailAddress. The email address is First Initial Last Name, so John Doe is [email protected]. I know how to string together the parts but don't know how to pull that first initial. Could anyone lend a hand? Thanks kindly!

Hi,

This is a really bad idea. Email addresses can be pretty much anything the account-holder wishes them to be. Some ISPs assign email addresses automatically and others let you choose your own. To me it's a non-automatable problem.

RW