Skip to main content
October 16, 2018
Solved

Export email addresses from QuickBooks online

  • October 16, 2018
  • 1 reply
  • 0 views

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.

Best answer by RenjolynC

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.

1 reply

RenjolynC
RenjolynCAnswer
October 16, 2018

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.

October 16, 2018
Is there any way to get postcode or street address separate?
December 11, 2018

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