I have an Excel worksheet of 750 entries, one column being names in the

format of Last, First Initial. This worksheet changes daily as
projects are being cancelled and added. I need a way to change the
names into email addresses. I do have outlook at my disposal and it
contains all the email addresses I need. ANY suggestion would be
helpful. I am stuck.

Hi,

I am not sure to understand your question / issue.

Do you mean that you have a list of names like let's say Math Murdoch
and you want to generate the email address corresponding to this name?

If yes, what is the structure of the smtp email in your organisation,
something like:




If yes, you can concatenate the smtp email address from the cell with
the " and use it to send the email.

I hope this helps.

Regards,
Karim Benabd

Hi,

I am not sure to understand your question / issue.

Do you mean that you have a list of names like let's say Math Murdoch
and you want to generate the email address corresponding to this name?

If yes, what is the structure of the smtp email in your organisation,
something like:




If yes, you can concatenate the smtp email address from the cell with
the " and use it to send the email.

I hope this helps.

Regards,
Karim Benabd

I have a list of M Murdoch and need to generate an e-mail address in
the form of

or
First6LettersofLastNameFirstInitialM...@c ompany.com

The problem is that I don't have their complete first names or middle
initials.

Is this even possible?

Hello,

Assuming your are using Outlook with Exchange Server, what is the Fully
Qualified Name structure in your company. Is it something like
Surname,FirstName,City ?