Due date reminder ahead of one month and mail that to customers?

dear sir/madam


Here there are 6 columns with 'n' number of rows. Column 'E' represents DUE DATE of

particular 'Sol ID' and this date is common for certain 'Sol ID'. My motive is to trace the

'DUE DATE' one month ahead. This I can do it by applying fillter option to column 'E'.

But that is not acceptable to my boss, he want such a way that there should be some

pop-up as and when we open this sheet. Kindly help me in resolving this issue