Hi Cranes
i didnt get your point, here in attached workbook in C & E column has dates and i doubt is when you want the excel send a Mail autamatic (means manually u will change the color of the cell or else it will change automatically )
suppose the Expiry date is 01-may-2014 and the cell color is green and as per your rule it will expiry in 60 days so automatic mail should be send before 01-june-2014 is it right
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi Naveed,
"suppose the Expiry date is 01-may-2014 and the cell color is green and as per your rule it will expiry in 60 days so automatic mail should be send before 01-june-2014 is it right"
No, sorry. If the date expiry is 01-may-2014 and the cell colour is green i would like an automatic email to be sent to inbox at 01-April-2014, Is this possible?
E.G. as soon as cell automatically turns green - excel sends an automatic email to inbox letting you know that the date is 60 days away.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks