Automatic create company e-mail from "first_name" and "last_name"

Here is my solution for creating a company email automatically from the existing last name field and the first name field (e.g. for address lists).

Input:
first_name: “John”
last _name: “Müller”

fx - formula column [with German umlauts]:
substitute(substitute(substitute(lower({first_name:} & “.” & {last _name} & “@yourdomain.com”), “ä” , “ae”), “ü”, “ue”), “ö”, “oe”)

Output:
email: “john.mueller@youdomain.com

Thanks for your contribution. I allowed myself to reformat your post minimally.

I think the “ß” is missing (for example like in “Waßmüller”) and you still will run in problems with non german names like André.

Thank You! Here ist a solution:
substitute(substitute(substitute(substitute(substitute(lower({first_name} & "." & {last_name} & "@yourdomain.com"), "ä" ,"ae"), "ü", "ue"), "ö", "oe"), "ß", "ss"), "é", "e")

adrewassmueller

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.