Skip to main content
Oct 16, 2018 12:50 AM UTC
Solved

Export email addresses from QuickBooks online

We're having a sale. I would like to send out a mass email to my customers from quick books online. I need to export emails from QuickBooks to excel.

RenjolynC
RenjolynCAnswer
Oct 16, 2018 12:50 AM UTC

Hi dentgear555,

Thanks for reaching out to us!

Here's how you can export a list of your customer's email addresses:

  1. On the left panel, click Reports.
  2. Type Customer Contact List in the search box.
  3. Click the Customize button located in the upper right-hand corner.
  4. Under Rows/Columns, click the Change Columns link.
  5. Put a check mark on the Customer and Email box.
  6. Click Run Report.
  7. Click the Export icon next to print and manipulate them there.

You can also send multiple emails to your customers by going to Customers > Batch actions > Email.

Please let me know if you have any other questions.

20 replies

RenjolynC
RenjolynCAnswer
Oct 16, 2018 12:50 AM UTC

Hi dentgear555,

Thanks for reaching out to us!

Here's how you can export a list of your customer's email addresses:

  1. On the left panel, click Reports.
  2. Type Customer Contact List in the search box.
  3. Click the Customize button located in the upper right-hand corner.
  4. Under Rows/Columns, click the Change Columns link.
  5. Put a check mark on the Customer and Email box.
  6. Click Run Report.
  7. Click the Export icon next to print and manipulate them there.

You can also send multiple emails to your customers by going to Customers > Batch actions > Email.

Please let me know if you have any other questions.

Oct 16, 2018 12:51 AM UTC
Is there any way to get postcode or street address separate?
Dec 11, 2018 10:42 AM UTC

Yes, please, me, too! How do you split them?