Changing names into email addresses using Excel/Visual Basic

[fujihamma]

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.

 

[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:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

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

I hope this helps.

Regards,
Karim Benabd

 

[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:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

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

I hope this helps.

Regards,
Karim Benabd

 

[fujihamma]

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

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

Is this even possible?

 

[Karim Benabd]

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 ?