How can I capture email addresses in customer reports

Hello there, GIC.

Thanks for joining us here in the Community. You're already on the right path in running the report and checking the information needed. Allow me to add some additional steps to make sure all the necessary details are captured.

As what my colleague @SophiaAnnL mentioned above, the report which can show the complete list of your customers name and their email addresses is the Customer Contact List. Once you select those options in the Rows/Columns section, all the clients will show regardless of whether there's an email address in their profiles or not.

At this time, the option to automatically filter a specific group of customers with email addresses is unavailable. You need to manually pick who has this information in the Filter section. 

Here's how:

1. Go to Reports in the left navigation panel.
2. Scroll down to the Sales and Customers section, then click Customer Contact List.
3. Pick Customize. 
4. In the Rows/Columns, click the Change columns link.
5. Remove all the check marks except for the Customer and Email boxes. 
6. Click Run Report and screenshot the entire list. 
7. Go back to the Customize button. 
8. Expand the Filter section.
9. In the Customer drop-down, put check marks on the customers' names with email addresses. 
10. Click Run Report. 

You now have a copy of those customers with email addresses. 

We'd also appreciate if you can share more of your thoughts about adding customization options with the reports in QuickBooks Online. We are always looking for ways on how we can improve the products that'll be beneficial for all users. 

To do so, just click the Gear icon, then select Feedback. 

Please let me know if you have additional questions with the process. I'll be around to help.

Have a great day!