Value lists, checkboxes, and calculations

[fishbone]

Hi, I have a sendmail script that needs to pull information from a value list and output the data into the sendmail messagebody.

In this case, we will say the db is named "myDB" and the value list is named "myVL" and the values are "1st class" , "3rd class" , "Airmail" , "No Mail"

I have a mail field that uses the checkbox format.

Using the code I have, let's say the user selects "1st class" and "Airmail"

In the message body using the sendmail feature, how do I pull "the checked data (in this case 1st class and Airmail") and post it into the message body.

This is all I have so far. I spent too much time on this and am stumped. Thank:

Trim("Linda, " & "¶" & "Could you please send mail for: " & "¶" & "to:" & "¶" & "¶" & Main::Comapny & "¶" & Main::Address & "¶" & Main::City & ", " & Main::State & " " & Main::Zip & "¶" & "Attn: " & Main::Contacts & "¶" & "¶")

[Sanjai]

You can use the middlewords function directly in your calculation above.

middlewords(Mail,1)

middlewords(Mail,2)

middlewords(mail,3)

middlewords(mail,4)

The middlewords function would not return any value if there are no words in the respective position. Hence if you have 1stClass and AirMail checkboxes checked then the value in Mail field would be

1stClass

AirMail

[fishbone]

Thanx so much. It worked! :