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