MailTo Formula Adding %'s to Emails
I'm trying to create an email list to send out to our end users. i used the TextList function to pull in all emails from a line item in a separate module. i have tried using both Commas and Semi Colons as separators. This line item is formatted as Text General.
The emails seems to populate ok in this line item. (i have blocked out some names)
Then in my mailto line item, formatted as text email, it adds lots of %'s and numbers into the email addresses. Formula below as i made line items for every part of the formula.
here are the emails that it's generating (i have covered names again and highlighted the %'s and numbers in yellow:
does anyone know what might be causing this and how to fix?