Auto-Emailing
I am currently doing the Gas Shelf Life Auto-Emailing. The data about the gases are in the EXCEL file. What I need to do are:
1) check few conditions of the gases such as expiry date less than 3months, flow status of the gas and shelf life remaining
2)email the end user of the gas.
The email part doesn't give me any problem. My problem is to read, store and compare the data about the gas. Right now my last row is 440 in the Excel and this figure will change in the future. Currently I'm doing LOOP and many problem occurs. It is a very complex Excel File.
Please respond here and I'll give the Excel File and My current code to you personally.
I thanked you in advance for kind consideration on my problem
|