taking multiple records and putting into 1 field

[pbucc]

ok i have 5 fields that have simple information in them. i need to make one field that will show the 5 fields of one record seperated by spaces then show the next record on the next line and so on.

what i am trying to do create a field that i can use in the email script function. we have people that have mobile pagers and i want them to see the infomation. they can't see attachments, just straight text.

any help would be nice.

Thank you.

[andygaunt]

Hi,

If you create a calculation field (_cAllFields) result of text.

Field 1 & " " & Field 2 & " " & Field 3 etc.

This will put all your fields into one field seperated by spaces.

Now, to put them all together create a global text field (_gEmail).

OK. Now, create a new layout (Get Field Lines) with just the calc field on it _cAllFields.

Now, in a script.

Go to layout Get Field Lines

Copy All Records

Go to layout (One with the _gEmail on)

Paste.

This will give you a return seperated list of all the records. In your script make sure you find the records you want first.

You can now put this _gEmail field as your email body.

you can even customise it further with set field statements before adding the _cAllFields

HTH