Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CheckBox field in a @MailSend formula

Status
Not open for further replies.

plc001

Technical User
Dec 23, 2002
15
US
Morning All,

I'm trying to send an e-mail from a form and I'm inserting several fields, but my issue is that if I insert a CheckBox field and the user selects more that one value, the @MailSend formula repeats all the other fields in the e-mail. For example, in the formula below, the field 'roles' is a CheckBox field and if the user selects two items I get:

"NAME: " + New_Full + @NewLine +
"Roles " + roles + @NewLine +
"E-mail Address: "+ email_add +

John Smith
HR
John@email.com

John Smith
IT
John@email.com

Can you help?
 
Found it:

@Implode(roles;", ")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top