Discussions

Expand all | Collapse all

Convert Name to Email Address

  • 1.  Convert Name to Email Address

    Posted 05-06-2019 21:13
    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!


  • 2.  RE: Convert Name to Email Address

    Posted 05-06-2019 21:16
    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


  • 3.  RE: Convert Name to Email Address

    Posted 05-06-2019 21:24
    Thank you!  I was making it more complicated than need be.  This worked perfectly.  Thank you again!