First Initial Last Name

[jayme01]

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 jdoe@domain.com. 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!

[ron G]

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

[Rick Whitelaw]

  On 2/25/2011 at 11:35 PM, jayme01 said:

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 jdoe@domain.com. 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