Hi everyone,
would like to find a formula or macro which would automatically send an email to let me know when a date entered into the specific cell is coming close to expiration. e.g. if the date 01/05/2014 is entered into a cell i would like an email to be sent to me a month before the date is reached (01/04/2014).
Using Microsoft Excel 2010.
Hi
check it out the attached file
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.
Drivers Names Phone Number Badge Number ID NO DDT Number DDT Expire Vendor Driver Licence Number IVMS Key Number
---------------------------------------------------------------------------------------------------------------------------------------
"Asset or Plate Number" "Item Description(Make and Model)" Chassis Number Location Sticker Number Vendor Sticker Expire IVMS Number
Hi Gents,
I have EX. with two tabs include the information above 1st for drivers & 2nd for vehicles with over 1500 drivers and vehicles.
every 6 months we need to make a re inspection of the vehicles and refresh for the driving course.
I applied many macros to email notification to show me which vehicles and belong whom need to re inspection, also for the driver but it just sends notification without information.
is there any one can help me how to receive a notification email showing all information above " one for drivers and one for vehicles".
please your help Gents.
Regards
Deyaa Aldin
Welcome Deyaa Aldin,
Please open your own thread and ask what you want to! see here http://www.excelforum.com/forum-rule...rum-rules.html
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Hi Naveed,
First of all, thank you so much for your answer!
However, its not quite what i am looking for.
I have attached a dummy spreadsheet describing the information that is in the real spreadsheet we have.
I have conditional formatting set up which turns the cell a different colour based on the date and how soon it is approaching.
Is it possible to have excel send an automatic email to me when the cell turns green, yellow or red?
Looking for ward to your reply, once again thank you so much for your help.
Last edited by MCCranes; 03-04-2014 at 06:45 PM. Reason: Forgot to attach excel spreadsheet
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
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.
hi,
try this, cahnge date for 5.apr.2014 in cell e4
then you can add this code to "Private Sub Workbook_Open()" and it generates email when you open the file if the condtion is met.
Please Login or Register to view this content.
HI,
how/where do you add that code?
HI,
how/where do you add that code?
madwizard,
pls see the instructions..
http://office.microsoft.com/en-us/ex...010236676.aspx
or
https://www.youtube.com/watch?v=2FjeohtTsIA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks