Collating field entries and adding formatting

[Doobeh]

Hi,

Essentially I want to grab all the e-mail addresses from the clients in my database, and then add a ; between each line, and then use that to send a mass mail.

example

user1 has clientEmail set to [email protected]

user2 has clientEmail set to [email protected]

user3 has clientEmail set to [email protected]

now, i want to grab all those records, and add a ; between then, so i end up with:

[email protected] ; [email protected] ; [email protected] ;

then I can simply use that in the e-mail script entry in filemaker to output it to an outlook mail.

sounds easy, ish whats your thoughts?

Regards,

Doobeh.

[bobsmith]

Create a value list using values from ClientEmail field, then create a calculated fied:

Substitute (ValueListItems ( dbname , valuelist ),"