By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
<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
Nov 13 '05 #2

P: n/a
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?
Nov 13 '05 #3

P: n/a
"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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.