This document will go over how to find all customer in your database that have email options selected under the customer billing section.
Overview
You will be required to access the SQL query located in the top ribbon of SedonaOffice.
Steps:
- Click on Query and choose Customer Query
- Highlight, drag, and drop the Customer Name into the Fields to Display
- Highlight, drag, and drop- Email_Cycle_Invoice, Email_Job_Invoice, Email_Service_Invoice, and Email_Other_Invoice.
- Select equals for the relation on all 4.
- Select Y for Criteria on all four.
- Click on the green arrow at the bottom of the screen.
