Oracle Fusion Cloud BI Publisher - Is there a way to flag the customers who already received email?

Hi,

We have an unapplied cash receipts report that shows customer's unapplied cash/balance due. We are trying to use bursting functionality to send individual emails/letters to all the customers from this report who have a balance due.

We would like to know how to identify/flag those customers who already have received an email/letter about their balance due so they will not receive another email again when running the same report.

Also is there the possibility of adding to the receipt information (Receivables--> Accounts Receivables-->Manage receipts --> Receipt information) like a field that we could flag when a letter was sent? If so, how can we set it automatically after we run the BIPublisher bursting query to indicate those customers have already received an email? We need a way to distinguish whether the email has already been sent to the customer or not.