I am using the amazing Mailer feature in CB to send out an email to new signups that choose the offline payment option where an email is sent to them with more details payment instructions.   It works like a charm as I am using the condition as follows:

Existing subscriptions
Any of the following plans subscriptions:  None is needed

Dates / CB Files Comparison
Date A. Field A or Value A:  Constant Value or String (CB Substations can be used)
Value A:  [PAYMENT_GATEWAY_ID]
Date B. Field B or Value B:  Constant Value or String (CB Substations can be used)
Value B:  1
Condition 1 (>for Dates):  A - B ( Value A is equal to Value B )

What I would also like to do is be able to send this to people that renew not just signups.

Question: Does the above condition trigger an email sent if it's a renewal (existing member whether expired or not)?   If not what other condition do I need to add so that people who choose offline also get an email with the payment instructions?

 

Here is what I have set in "Main Mailer Triggering Conditions"

 

From the Mailer logs, it doesn't look like renewing members got an email.   Though I would also need to double-check the cronjob is working since the last time I tested it.

If this needs to be adjusted for the "renewal" scenario sounds like I may need to make a duplicate trigger.

 

Thanks.  You are right.  Even if the cron runs daily and has already run and someone renews that day would have missed the trigger.  I will check to see if the cron was set to daily ( I set it quite a while ago)

I have changed to 2 days after which should hopefully catch all conditions.

Speaking of Mailer,  I take it I can also use this tool to send out renewal reminders for something like 1 week before and 24 hours before the expiry date.
If so, is there a tutorial anywhere to walk me through the steps to cover everything?    I can see there are conditions related to renewal dates to look at as well as the "Main Mailer Triggering Conditions.    (I'm happy to start this as a new post if its better for someone else looking to so the same.)