Automatic mail on due date (30 days or closer)

I am trying to do a vba script so that i run excel using microsoft scheduler and if it finds something which is due in 30 days it will auto0matically send a mail. now for the first column its working fine but for the second it stops. can anyone help me please

Please Login or Register  to view this content.

Instrumentation Logsheet - Copy.zip

Hello and welcome to the forum.

I have problems running too ... but more to do with damaged cartilage and ligaments

Unfortunately, you have broken a couple of the forum's rules s it may be best to look at them before a solution can be persued. Your thread title needs to be amended to something relevant ... you can see how your current title will attract interest from people who may not have much to do with Excel. And you need to add code tags.

While you're there, you could add a sample workbook so the code can be tested.

Regards, TMS