Hi! Working in FM5, mac and PC...

we have a database of a few thousand customers that includes an email address, each customer having it's own record.

Is there a quick way to make those email addresses into a list, separated by a comma, so could easily copy/paste into an email program?

Thanks for any help!

Export to a text file. Edit text file in word processor to replace returns with commas.

perfect, Thanks Ralph!!!

(wow, sometimes you try so hard to come up with something that you forget the completely simple and OBVIOUS) :

Or you could define a global field "G_EmailAddresses" and the script:-

Go To Record First

Set Field G_EmailAddresses = Email

Go To Record Next

Loop

Set Field G_EmailAddresses = Field G_EmailAddresses & ";"& Email

Go To Record Next Exit After last

End Loop

Copy G_EmailAddresses

You would have to ensure that the field G_EmailAddresses exists on the layout for the "copy" step to work.