value field to email address

[baweld123]

Hello, Hopefully somebody may know this and i bet its really easy but scripting to me is still the dark arts but I'm trying to learn. I have a field that is a value list of names and i want this name to be changed to an email address so that it can be sent to that person. i.e. "Paul"  = [email protected].  "bert" = [email protected] etc

How do i do this in the calculation field.

Many Thanks

 

[Kris M]

calculationfield = namefield & "@address.com"

calculationfield must have text result

[baweld123]

Brilliant !! How clever is that :-) 

easy when you think of it i suppose 

Thanks for that Kris

[comment]

How do i do this in the calculation field.

​Why do you need a calculation field for this? If this is for sending mail, you can calculate the address directly in the Send Mali script step.

[Kris M]

Far from brilliant. Just a simple string concatenation.

My advice it to get intimate with all of the string manipulation functions before you try to build anything really complex.

Also look into the Send Mail script step as comments question is on point.

[baweld123]

ok thanks both for advice