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

ckim551

  • Jr. Member
  • **
  • Posts: 9
How to find a clubber with non-Primay E-mail?
« on: March 04, 2020, 03:03:13 PM »
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

Rick Leffler

  • Administrator
  • Sr. Member
  • *****
  • Posts: 339
    • Approved Workman
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 in the Windows Remote Client app (AWdbRemote) 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'
Rick at Leffler Systems
Murfreesboro, Tennessee

ckim551

  • Jr. Member
  • **
  • Posts: 9
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.