Author Topic: Divorced parents = child has 2 homes = need to email both parents  (Read 4112 times)

DebLiveOak

  • Jr. Member
  • **
  • Posts: 9
  • now that's what I call multi-tasking
    • FBC Children's Ministry
Divorced parents = child has 2 homes = need to email both parents
« on: September 23, 2020, 09:05:49 AM »
Note: This post is applicable in the Cloud database's Windows App as well as in the Legacy database.

I've read all the posts I could find regarding multiple emails but didn't see this asked or answered. We have multiple children that spend 50% of their time with each parent. Both parents want to receive communications from us. I've not found an EASY way to do this. Selecting the primary email means it only goes to that parent. If they aren't "friendly" then they don't share with the other parent.   :-\
If there's an SQL workbench for this, I would LOVE to have it.
« Last Edit: March 24, 2022, 11:19:10 AM by Annette »
Director of Preschool & Children's Ministries
First Baptist Church
Live Oak, Florida

Annette

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 145
Re: Divorced parents = child has 2 homes = need to email both parents
« Reply #1 on: September 24, 2020, 01:47:07 PM »
First, I assume you are using the Gather E-mail addresses and Textible Phone Numbers tool.  If you are using the selection by Household Status, you are correct that it will only return the primary email. However, if you use the specific selection criteria (Club Name, Member Type, etc), it will find any linked emails to someone meeting the criteria. So, the key will be how you set up your contact records.  I tested this for one family, so I think it will get you what you want. Here's the example:

Say James is a Sparks clubber in this 50-50 situation and you need to be sure the email goes to both parents.  In the Member Form, open the contact record.  In the row that has Mom's email, set the Member Link field to James.  Also in the row that has Dad's email address, set the Member Link field to James.  When you gather email addresses for Sparks clubbers, it will find any email address linked to a Sparks clubber, in this case James, so both email addresses will be returned.

If there are multiple children in the same household in the same situation, say Jonah is a T&T clubber in the same family also 50-50, you would need another set of records with Mom's email linked to Jonah and Dad's email linked to Jonah so when you gather addresses for T&T clubbers it will also get both addresses.

The process removes duplicate email addresses, so if you run it for "All Clubs" and "Clubber" or "Sparks and T&T" and "Clubber", you should only get Mom's address once and Dad's address once even though they are linked to two clubbers.

Give it a try and let me know how it goes!
« Last Edit: September 24, 2020, 03:21:57 PM by Annette »

DebLiveOak

  • Jr. Member
  • **
  • Posts: 9
  • now that's what I call multi-tasking
    • FBC Children's Ministry
Re: Divorced parents = child has 2 homes = need to email both parents
« Reply #2 on: September 28, 2020, 09:50:44 AM »
That did work. For some reason, I assumed it would only pull the "primary" email and never ran it for the purpose of verifying that assumption. But I just ran it and saw both parents in the email box. And I also verified that if I run a clubber report for their Awana leader it will also show both phone numbers and email addresses. Now to just figure out the mailing address.   ;D
Director of Preschool & Children's Ministries
First Baptist Church
Live Oak, Florida