Send email Script for dummy

[Sebastien Bergeron]

Hi,

I Am trying to use the "Send email" scripting function.

Now let's say I am on a record that contains multiples fields that store email addresses. I want to be able to specify more then one fields in To: mytable::staffemail1 ? How can I do that without using CC: mytable::staffemail2. You know just the way you do it when typing regular email adresses eg: [email protected], [email protected], [email protected] ect . . . . but using multiple field contain ?

[mr_vodka]

Try something like:

Substitute ( List ( Email_1; Email_2; Email_3; Email_4 ); ¶; ", " )

That being said, you should probably have the emails in a separate table if you have multiple fields for them.

[Sebastien Bergeron]

It worked like a charm !

Thanks a lot for your kind help.

Now I am not sure to understand what you mean by "have the emails in a separate table if you have multiple fields for them."

Each individual email address in a separate table ?

[mr_vodka]

Yes. To properly normalize this database, you should have each of the email addresses in its own record in a separate Email or contacts table.