PDA

View Full Version : SEND EMAIL DUE DATES WITH FORMULAS IN SPREADSHEET



tfarm
09-01-2008, 04:40 AM
Hello Everyone,

I am having the hardest time trying to find examples or solutions to my issues (which I am sure I have made larger than required). I have used some coding that I was helped with that sends an email with comments of due dates. The code works. I then tried to stretch it out to use it in another way. (I know...that is the problem :( )

I am trying to create a Maintenance scheduler that will email the due dates and item that needs serviced.

I was successful with the conditional formatting of red cell on due date.

Problems:
1. Once I added formulas into the range(d2:t23), instead of manually entering each date; the results of the formula are not being recognized. What code do I need so that the formula result is calculated?

2. I want column D to continue to have the ability to be changed by the user which then will effect the due dates on that row.

(I changed column C to multiples of weeks so I see that I can simplify my formula as a standard formula across the range)

Any help will be greatly appreciated:bow: :bow: :bow:

I wish one of your guru's were here in Fort Myers Florida so I could schedule some classes from you!!!!