Skip to main content
Topics#EmailSarai Bravo's Question
Sarai Bravo asked in #Email
Jan 16, 2015, 6:01 PM

Extracting First and Last names from an email?

Is there a way to extract first and last names for contacts from their emails? We have set-up an email syntax for the accounts which creates a possible email based on their names. 

 

 
2 answers
  1. Eddie Zaragoza (SCS Cloud)
    Apr 15, 2024, 4:59 PM

    Several years late to this but posting in case anyone else needs it. My use case is when someone emails into a Salesforce case but they are not yet a contact, I would like to create a contact for them with the Supplied information.

     

    I'm handling this with two flow formulas:

     

    First Name

    New Resource: Formula

    Data Type: Text

    Formula: LEFT({!$Record.SuppliedName}, FIND(" ", {!$Record.SuppliedName}) - 1)

     

    Last Name

    New Resource: Formula

    Data Type: Text

    Formula: RIGHT({!$Record.SuppliedName}, LEN({!$Record.SuppliedName}) - FIND(" ", {!$Record.SuppliedName}))

Write an answer...
0/9000