Mail to: Multiple records, multiple fields

Question

Looking for a way to do a 1 click "email to" a list of contacts and their admins.

I have the emails of both, with the ability to "email all" at the bottom of the table.

I have a formula-url field programmed w/ email and Cc.

I can't find a way to program 1 button (or other suggestion) to pull all folks in a filtered list and send it to the default email client. Currently, I have table reports for each "group," download the spreadsheet, copy and past email address to either "TO" or "Cc" as needed.

Any suggestions?

------------------------------
Erik Pye
Affirmant Health Partners
-Learner -Includer -Developer -Positivity -Belief
------------------------------

MarkShnierYou · Answer

So you are sitting on a contact record and there is an embedded child table of admins?

If that is the case, you can create a text field which mirrors the email field on the child table but converts it to text,. Then use a combined text summary field in the relationship to get those email addresses up to the Parent contact.

Then convert that back to a text field using

SearchAndReplace([All Admin emails]," ; ",";")
That should remove the spaces around the semi colon and convert to text.

Then use that in your MailTo: formula.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community