Replace characters in mergefield
Hi all,
I'm sure this has been asked before but I can't find it on this fine forum!
I am new to using mergefields and I am hoping to do some manipulation on the data within one. I have a field that contains employee names i.e. "Firstname Lastname" and I know that the standard form for company email addresses is "firstname.lastname@companyname.co.uk".
My question is is there a way within mergefield if formulas to automatically format the name field to an email field i.e. replace the space with a "." and add the email url at the end?
Thanks in advance.
Regards
Tom
|