Author Topic: How to find a clubber with non-Primay E-mail?  (Read 3282 times)

ckim551

  • Newbie
  • *
  • Posts: 3
How to find a clubber with non-Primay E-mail?
« on: March 04, 2020, 03:03:13 PM »
Note: This post is applicable in the Legacy database as well as in the Cloud database's Windows App.

I've sent out an email to parents and got some returned email due to wrong email address.
I've got the email list using Gather Email Addresses.

Apparently the wrong email address is not a Primary Email.
How do I find out which clubber that wrong email address belong to?

Thanks,
Charles
« Last Edit: March 24, 2022, 11:20:33 AM by Annette »

Rick Leffler

  • Guest
Re: How to find a clubber with non-Primay E-mail?
« Reply #1 on: March 04, 2020, 05:21:18 PM »
You can use the SQL workbench under the Tools menu to find which household the email address in question belongs to.  Type (or copy/paste) the following statement into the SQL Workbench and replace "email@gmail.com" with the actual email address you're looking for:

select h.filing_name as Household, c.display_as, c.contact_person  from household h, communication c
where c.household_id = h.id and display_as = 'email@gmail.com'
« Last Edit: March 22, 2022, 09:36:14 AM by Annette »

ckim551

  • Newbie
  • *
  • Posts: 3
Re: How to find a clubber with non-Primay E-mail?
« Reply #2 on: March 04, 2020, 06:05:45 PM »
That worked perfectly. Thank you for quick reply.