Calc or Script?

[RET]

Oh I got sooooooo many questions today!

OK! I would like to create a field that would contain all the results found from another field. In other words If I have a e-mail address field, how do I have a another field conatin all the results of all records found in this field?

I not exactly doing this but this was my best example.

RET

[LiveOak]

What do you consider a "result" and how can "all records be found in a field"? Maybe you should tell us exactly what you are trying to do, something is getting lost in the translation.

-bd

[RET]

Example:

Field1 = email addresses for each record.

Field2 = conatins all of the email addresses together...for every record, or every record found.

[LiveOak]

Yes, there is a fairly easy, if not at all obvious, way to do this. Create a list view layout and place only Field1 in the body of the layout, no field label, no other graphics, field or objects, period. Then 1) create the desired found set, 2) navigate to this new layout, 3) perform a "Copy All" script step, 4) navigate to a layout with Field2 visible, 5) paste to Field2.

This will put all the email addresses in Field2, delimited by carriage returns.

As an option, if you use an email plug-in such as SMTPit from Comm-Unity. It has an External function that will append email addresses to the "To:" field in the email message created.

-bd