We'll have to pull up two reports, export them to excel, then combine them so we can achieve what you need, ABSC.
I'll guide you with the steps.
First, we'll have to pull up the Sales by Customer Summary report and customize it to show customers with no sales within a certain time frame. Here's how:
- Click Reports, then go to Sales.
- Select Sales by Customer Summary.
- Change the dates to the period desired.
- Click the Sort by drop-down arrow, then select Total.
- Click Customize Report, then click Advanced.
- Under DISPLAY ROWS, select All, then click OK.
- Go to the Filters tab.
- Under Account, select All ordinary income accounts, then click OK.
- Click the Collapse button.

Next, here's how you can export the report:
- Click Excel, then select Create New Worksheet.
- Click Create new worksheet, select in new workbook, then click Export.
Then, let's export the customer list so we can get their emails and addresses. Here's how:
- Go to Customers, then click Customer Center.
- Click Excel, then select Export Customer List.
- Click Create new worksheet, select in new workbook, then click Export.
Once done, you can combine both reports. Although, it won't provide the last purchase date, you'll want to check each customer for the needed information.
I'll also share the article on how you can create, access and modify memorized reports for future reference.
You can tag me if there's anything else that I can do for you. I'm just around to help you out.