Convert Name to Email Address

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
Okay, QB Friends, I am stumped on this one.  I have a list of Supervisor Names and I am trying to convert them to email address.  Here is the example.  I have a linked field with the names.  So, I have John Smith as a connected text field.  I need his email address to be John.Smith@domain.com.

So far, I have managed to separate "John Smith" into two fields: [Supervisor First Name] "John" and [Supervisor Last Name] "Smith", but I am stumped as to how to covert this into an email address.  I have tried this text formula:

List(([Supervisor First Name]),".",(([Supervisor Last Name])),"@domain.com)")

This doesn't work and gives back .JohnSmithJohn.@domain.com
I'm stumped.  Can anyone guide me in the right direction?  Thank you!
Photo of Kim Gaston

Kim Gaston

  • 244 Points 100 badge 2x thumb
  • sure you can help me

Posted 2 months ago

  • 0
  • 1
If they're all text - you should be able to just do

[Supervisor First Name] & "." & [Supervisor Last Name] & "@domain.com"

You could probably add a catch too and do a quick Trim() to clear any white space for good measure

Trim([Supervisor First Name]) & "." & Trim([Supervisor Last Name]) & "@domain.com"

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
(Edited)
Photo of Kim Gaston

Kim Gaston

  • 244 Points 100 badge 2x thumb
Thank you!  I was making it more complicated than need be.  This worked perfectly.  Thank you again!