Forum Discussion

KimberlyGaston's avatar
KimberlyGaston
Qrew Cadet
6 years ago

Convert Name to Email Address

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!
  • 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
    • KimberlyGaston's avatar
      KimberlyGaston
      Qrew Cadet
      Thank you!  I was making it more complicated than need be.  This worked perfectly.  Thank you again!