Filling out a email body using using a template given by client

Help
1

I’m sending out an email and Im following a template guide line from the client. Everything that needs to to filled in comes from an excel file. My problem is that the way the name is written in excel is “LastName, FirstName” How pull from excel but write the First and Last name instead of the other way around. I would not be oppose to just using the first name.

2

Hi @seanp92

If the names are always in the same format, then a simple split function will do what you need. See this example:

image
image925×598 16.6 KB

Likes so:

inputString.Split({","}, StringSplitOptions.RemoveEmptyEntries)(0)
inputString.Split({","}, StringSplitOptions.RemoveEmptyEntries)(1)