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?

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

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.

Pls post the script.