Compile error variable not defined

[AsifShabbir]

Hi,

I am using macro of Ron for auto mail generation and I have modified it according to my need but as for as I use the original sheet of Ron and make changes on it, it works but when I copy this code into new sheet it gives error message Compile Error: variable not defined. Please help me solving this.

I am attaching the sheet in which I am using this code. In this sheet I want excel to generate mail when 42 days left in review date.

2nd thing I want excel to do is generating a reminder mail when 10 days left in review date and show in Reminder column whether reminder sent or not.

Waiting help for you experts.

Asif