How to create an e-mail as a sum of columns?

[atarumorooka]

Hi, my company has about 3000 employees and I have their names and
family names as two columns of my db.
Because the e-mail address of my company is made this way:
Name: name
Family Name: familyname
email address is: nf*********@xyz.com

I'd like to create a column having automatically the first letter of
the name plus the family name plus the @xyz.com

How to do that?

Thank you.

Ataru

[Fred Zuckerman]

<at**********@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi, my company has about 3000 employees and I have their names and
family names as two columns of my db.
Because the e-mail address of my company is made this way:
Name: name
Family Name: familyname
email address is: nf*********@xyz.com

I'd like to create a column having automatically the first letter of
the name plus the family name plus the @xyz.com

How to do that?

Thank you.

Ataru

=Left([Name],1) & [Family Name] & "@xzy.com"
Note: You shouldn't use reserved words (like: "Name" ) for field names.
Fred Zuckerman

[Salad]

Fred Zuckerman wrote:

<at**********@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi, my company has about 3000 employees and I have their names and
family names as two columns of my db.
Because the e-mail address of my company is made this way:
Name: name
Family Name: familyname
email address is: nf*********@xyz.com

I'd like to create a column having automatically the first letter of
the name plus the family name plus the @xyz.com

How to do that?

Thank you.

Ataru

=Left([Name],1) & [Family Name] & "@xzy.com"
Note: You shouldn't use reserved words (like: "Name" ) for field names.
Fred Zuckerman

I wonder what he does when he has a John, James, Jane, June Smith?

[Fred Zuckerman]

"Salad" <oi*@vinegar.com> wrote in message
news:0q*****************@newsread3.news.pas.earthl ink.net...

Fred Zuckerman wrote:

<at**********@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi, my company has about 3000 employees and I have their names and
family names as two columns of my db.
Because the e-mail address of my company is made this way:
Name: name
Family Name: familyname
email address is: nf*********@xyz.com

I'd like to create a column having automatically the first letter of
the name plus the family name plus the @xyz.com

How to do that?

Thank you.

Ataru

=Left([Name],1) & [Family Name] & "@xzy.com"
Note: You shouldn't use reserved words (like: "Name" ) for field names.
Fred Zuckerman

I wonder what he does when he has a John, James, Jane, June Smith?

I suppose his HR dept catches that during job interviews and won't hire
duplicates. :)
Fred Zuckerman