Copy email addresses from a portal result into a field.

[etsmarines]

I have a portal that displays a list of people depending on certain checkboxes I select. How can I take the contacts listed in the portal and copy their email addresses into a "TO Field" so i can send a mass email to the people that were listed in the portal?

[bcooney]

Use List ( )., However, I wouldn't put it into To, perhaps BCC.

Or loop thru the child people records, sending an email to each (better method, imho).

[etsmarines]

How do I do that? Thanks Again!

[bcooney]

Do which?

[etsmarines]

Loop through each one to get their email and put it into the CC field

[bcooney]

Actually, when you loop thru people, you'd put their email address in the To. Each person gets their own email.

You mention portal of people. Just use that relationship to go to related records (people) and then loop.

[etsmarines]

Here is what I want to do.

When my portal populates with a list of contacts I want to be able to extract only the email address of each one and merge them all into my email layout in the TO: field. So that for example if jon jim and joe appear in the portal I can hit a button and it will switch to my email layout and in the TO: field will be the 3 addresses of Jon Jim and Joe so all I have to do next is create my message and hit sent and it will send to all 3 of them. i just dont know what script to create to get this function to work.

[bcooney]

"merge them all into my email layout in the TO: field"

What table is the email layout based on?

Attach a script "Send Email" to the button above your portal. The button also sends as a scriptparameter the list of email addresses using List (relationship::emailfield).

In the Send Email script, you'd go to Email Layout, do a new record and use Set Field [To, Get (Scriptparameter)].

I'm not certain, off-hand, if you can use returns as delimiters btw addresses, or you'd need to substitute commas.

[etsmarines]

thank you!