Hi,
When due date is greater than 29 days, then automatically excel send mails to clients whose due date is greater than 29 days.
Ex: A, B due dates are more than 29 days so excel automatically send mails to respective clients. After
3 days C,D F,I,L clients due dates will be greater than 29 days. Then excel automatically send mails to those 5 clients without my involvement.
Please help me on this issue.
thank you in advance.
I did this in two parts. First, I inserted a line and stored a date in D1.
Without a recurring constant the macro would run infinitely because TODAY() is a volatile function that recalculates constantly. At the end of the run, D1 is updated.
Please Login or Register to view this content.Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks