Mailer - How to mail unpaid members after 5 days of not receiving payment

Can anyone help. I need to send reminder emails to members who have agreed to pay offline for a subscription after 5 days having not received the payment by other means. i.e. by cheque. (So the subscription is active but unpaid)

I can see that I need to use conditions in Mailer but am not quite sure how to do it.

Rgds, Chris.

Hmm, I believe the below might be able to do this. By being paid the subscription should become Active so you should be able to condition based off the subscription state.

Automatically send message at following date: 5 days after
Relative to this date of the plans below: Subscripton's subscription date
To which plans this date condition applies: SELECT_PLANS_HERE
Must be in state: Registered Unpaid
But do not send message if it's later than: 6 days after (suggesting this to avoid spamming them as ideally you'd trigger processing daily)

That should ideally send your mailer if 5 days after their subscription date the select plan(s) are still unpaid.