help me simplify my FM emailing

[Donkick]

I have a client database with a related table for email addresses.

I also have a client field called "email_list" that is a List calculation so that shows a list of all emails related to a specific client with a return between, all within one field.

The email script sends mail using the Send Mail script step to the related field "email_list"

It works sometimes, but not always. I can't seem to isolate the common thread as to why it does not work all the time.

The reason I did it this way was so I can send to multiple addresses for a single client.

Is there a better way to accomplish this goal and just avoid this whole mess?

[bcooney]

"It works sometimes, but not always." What does that specifically mean? Could be it encountered an invalid address?

[Donkick]

Sometimes it populates the T0 email address with all the emails in the database, other times it populates it with the same email over and over again.

[bcooney]

Pls post the script.