I have a list with workflows that was created for one of our clients that allows them to enter some information and the workflow takes care of sending emails to the necessary recipients as well as notifying the person the task is assigned to when it has
reached a certain status or age.
The "agent name" colum contains the agent's first and last name (ie John Smith). I am wondering if there is a way that in the workflow, when an email is generated, if I am able to remove the last name using some sort of text calculation. The
reason I would like to try and do it this way if possible is that if I add the Columns Agent First Name and Agent Last Name, the current Agent Name colum that is being used to generate the agent's name in the email will now not be the correct column to use
for this information and the 100s of entries already in the lists will not send out emails properly.
Does anyone have a suggestion for this, or know some sort of text calculation formula that I can use to remove the last name from the lookup in the email?
View Complete Post