How to Export Billing Email Addresses

Export Billing Email Addresses

1. Log into the reporting site. (https://store.company.com:8080)
   Or, click Plugins, Reports, and Order Detail Report.
   
   
   
   
2. Use the Date filters to specify a date range.  Set the Location filter to All.
   
   
   
   
3. Click the CSV button to download the raw data in comma delimited format.
   
   
   
   
4. Open the CSV file in Excel.  Click OK.
   
   
   
   
5. Delete all columns except BillingEmail and any other fields that might be used in your email campaign marketing software (i.e. BillingFirstName, BillingLastName, etc.).
   
   
   
   
6. Click the Data tab in Excel.  Select all data.  Click the Remove Duplicates button.
   
   
   
   
7. Click Unselect All/My Data Has Headers /BillingEmail.  Click OK.
   
   
   
   
8. Click OK.  Duplicates should be gone.