[Vikashee]

I have read reviews on forum on same . But still could not find a soultion probably becoz i am not savy with excel . We are basically in to procurement of material . Currently the problem we are facing is that we are not able to track ,whethe the credit period of the supplier has finished and we have paid him or not ? From best of my excel knowledge i was able to establish a formula for same and was sucessful too .i was getting information on Gap b/w payment date and todays date .Moreover I got visual indicator for same , by conditional formatting . Now my boss wants me to make a provision in the excel sheet that once teh payment date has expired , he should keep on getting reminder for same as outlook message with suppliers name and order detail . I have tried alot for same on base of information given on the forum and infact downloaded and installed Click yes active. ver1.2 too Since i dont know VB so i am not able to solve thsi problem. Can any one help me on ths issue as it is important for my promotion .The file is ready for me and can be uploaded on request .

[OBP]

Vikashee, welcome to the forum.
If you wish to do this while Excel is open a VBA macro can do that for you, there are already a few Examples on here.
If you want to open Excel and do the test you will need some VB Script or to use Windoes Task Scheduler.
It is a pity that your Boss is Excel orientated as Access is a much better platform for Material Procurement.

[Rollin_Again]

Can you post a sample workbook showing your data layout?

Regards,
Rollin

[slurpee55]

Zack did most of this last year. Here is the link to his work:
http://forums.techguy.org/business-a...rts-using.html

[slurpee55]

Or, Daniel Curran has made a sheet that is simple to use and free to download:
http://danielcurran.com/outlook/how-...il-from-excel/

[Vikashee]

thanks for ur replies . I was out of town so i could not respond immediately . Please find enclosed the file .
I am also mentioning the thread ,which I have used for intial reference . Now doubt their was a goodexplanation but i was not bale to grasp much of it. Could u suggest me a simple VB program , which i can copy paste in the sheet or a simple excel formla so that it starts working . I really thank you guys for bearing with me and supporting me .
http://forums.techguy.org/business-a...s-using-2.html

[slurpee55]

First, I would suggest you change your formula from what you have in column A to
=IF(H6="","",IF(J6-H$2=0,"",DAYS360(H$2,J6)))
Then you can drag the formula down A and it will not give you a bunch of cells that look like #####. due to today's date being entered there in a negative (e.g. Nov. 6 as a negative is -39546.)
This formula also has some problems, given your conditional formatting, but not as much as you would have had.
Oh, also, the "$" in H$2 forces the formula to always look at that cell - if you drag the formula down the column without the dollar sign, it would then look at H3, then H4, and so on.

[Vikashee]

I have gone through Daniel Curran excel sheet ( t3.xls) it is really simple to use but only a partial solution to my problem . If I correlate my requirement to his sheet then it can be explained as follows . In the given sheet (t3.xls) u have to click sent mail , however my requirement is auto trigger ,i.e mail should go on its own to the desired email id . the condition is that the trigger should be set once a condition is met , say in my case ( t2.xls ) delay period when reaches 7 days the mail should shoot to the given email id . Can u help me understand the same by customizing t3.xls , with any such if then condition and setting a auto trigger .It would be really great if u could make necessary changes in t3.xls VB program . Thanks again