make email list?

[stevec]

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!

[RalphL]

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

[stevec]

perfect, Thanks Ralph!!!

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

[Robert Kidd]

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.