Send Email to Customers Question

[Limitless]

Select
  customers.customers_firstname,
  customers.customers_lastname,
  customers.customers_email_address,
  orders.customers_name,
  orders.date_purchased

From
  customers Inner Join
  orders On orders.customers_id = customers.customers_id
  where date_purchased <= DATE(DATE_SUB(NOW(),INTERVAL 7 DAY))