Send monthly notices of penalties for overdue payments

Hello,
Am Prem & I have a problem to which I seek your assistance. I have an excel file wherein the details of monthly fee collected from different IDs is captured month-wise. If the fees is paid on time (i.e., on or before the 10th of every month, no penalty is levied). But if the fees is paid after 10th of the month for which it is due, then penalty is to be levied from the 11th day of that month (the month for which the fee was due) till the current date, at the rate of Rs.5/- per week. I should be able to send a demand notice on the 1st of every month which should also list out the dues & the penalty incurred to every member. I need a vba code to do this. Pl help me in this regard.

I have attached a sample file herewith without any code.

Thanking you in anticipation of a favorable reply / solution .

Regards,
Prem.

Welcome to the Forum empk!

As a new user, please take the time to review our rules. There aren't many, and they are all important.

Rule #1 requires good titles that gives insight to your question. "VBA Macro code" does not do that.

I have changed your title for you since it's your first post.

Generally you will get better participation if you have done some work on your own and need help to solve a specific problem. You may find someone willing to develop your project from scratch for free, but if not then consider using our Commercial Services forum to offer a modest payment.