Compile error variable not defined

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

Hi 6StringJazzer,

No it doesn;t work as now it gives message (Runtime Error 91: Object variable or with block variable not set). Further in the original worksheet of Ron, he hasn;t added this line as I have changed only Formula range and in mail code ( in my case module 1) the body of the mail.

Thanks

No its not working. Have you tried it? may be I am doing some mistake. another confusion in my mind is that I have copied all the codes from Ron's sheet but its working on his sheet but not on mine. what is the logic?

Thanks

By the way it is now giving original message i.e compile error: variable not defined. Sorry to add one more thing that I want excel to initiate mailing process ( for reminder) in the way like Ron did i.e. Sen or Not sent message in nex column (Column G) and I want Reminder sent or Not sent in Column H.
I hope, I am not bothering you

That's what I am trying to do but unsuccessful.