Created attachment 3897 [details]
cronjob file

This is a cronjob hacked from advanced_notices.pl to send out emails to patrons nearing account expiry.
The notice template code is hardcoded to EXP so make sure you modify only that notice template. and it can handle  borrowers.borrowernumber, borrowers.title, borrowers.firstname, borrowers.surname, borrowers.dateexpiry fields in the notice.
The number of days to expiry can be set with a command line switch -m
The script puts the emails in Koha's default message queue so its system compatible.

It can be improved in a number of ways like for create syspref for sending these reminders, and setting the days in advance.

I can submit a patch if this is useful..