cancel
Showing results for 
Search instead for 
Did you mean: 
Jim-vitalplan
Level 1

How can I capture email addresses in customer reports

 
7 Comments 7
SophiaAnnL
Moderator

How can I capture email addresses in customer reports

There's one report that displays this information, Jim-vitalplan.

 

You can pull up the Customer Contact List report to see your customers' email addresses. Other transaction reports can't capture this information at this time. I'd recommend sending feedback to our developers to have this option available. You can send them through this link: https://feedback.qbo.intuit.com/.

 

Here's how to pull up the report:

  1. Click Reports on the left panel.
  2. Type Customer Contact List in the search box.
  3. You'll see an Email column showing the details you need.

Feel free to get back to me if you need anything else.

GIC
Level 2

How can I capture email addresses in customer reports

Is there a way to create a report showing only customers that have email addresses? I've checked just the customer and the email address but it pulls up all the customers - including those without an emails.

VivienJ
QuickBooks Team

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!

GIC
Level 2

How can I capture email addresses in customer reports

I'm showing my lack of computer skills but...how do I screen shot the whole list? 

VivienJ
QuickBooks Team

How can I capture email addresses in customer reports

Thanks for your quick response, GIC.

 

Worry no more! I'm here to continuously guide you through getting the information you need.

 

The screenshot step I’ve introduced in Number 6 is an option you can use to have a separate copy of the customers’ list. This can be your guide in selecting those customers with email address in the Filter section.

 

Here’s how you can screenshot:

  1. Press Ctrl + Print Screen on your keyboard.
  2. Open a Microsoft Word Document or Powerpoint, then press Ctrl + V.

If you’re unable to do the process, you can print a copy of it instead. Just click the Print icon prior to customizing it again. Please refer to the screenshot I’ve added above.

 

These steps should help keep you moving.

 

Don’t hesitate to let me know if you have other questions. I’d be delighted to answer them for you.

 

 

GIC
Level 2

How can I capture email addresses in customer reports

Thank you so much!

VivienJ
QuickBooks Team

How can I capture email addresses in customer reports

It's my pleasure to help, GIC!

 

I’m glad you’re able to get the details you need in the Customer Contact List report. Rest assured that I’m always here to help the best way I can.

 

The Community is a great place to connect with accountants and other users. If you have future QuickBooks concerns, feel free to join us again here in the Community.

 

More success to your business!

 

Need to get in touch?

Contact us