Can I concat multiple related module records into one text area?


I am trying to create a text field which concatenates all names/emails from related records.

e.g. In the Accounts module I want a field that lists out each of the contacts related to the account and to concatenate the fields (Name) and (Email address).

I have managed to setup a test field that concatenates for 1 record but have been unable to do it for all existing related contacts. Can this be done?

As always help greatly appreciated.

Many Thanks