VNouBA
06-27-2012, 11:22 AM
Good evening,
I am looking for a VB code online but with no explanation and no success.
I have a date in my worksheet (Column C); usually this date is a future date. I need a code that when that date is the present date it will send me an email with the following:
If date is today then send email:
Subject = File number “Range(Cells(Target.Row, 1)”
Note: The “Range(Cells(Target.Row, 1)” will trigger what is in my Column A vs. that date that is triggered and add it after File number.
Example: If C5 is Totay() and A5 = W123-123456 then Subject will be File number W1234-123456
Message: “File number “Range(Cells(Target.Row, 1)” will be taken off the system at 02:00 PM.”
Note: The “Range(Cells(Target.Row, 1)” will trigger what is in my Column A vs. that date that is triggered and add it after File number.
Nothing online that I have found…
Thank you so much for all you geniuses :D
I am looking for a VB code online but with no explanation and no success.
I have a date in my worksheet (Column C); usually this date is a future date. I need a code that when that date is the present date it will send me an email with the following:
If date is today then send email:
Subject = File number “Range(Cells(Target.Row, 1)”
Note: The “Range(Cells(Target.Row, 1)” will trigger what is in my Column A vs. that date that is triggered and add it after File number.
Example: If C5 is Totay() and A5 = W123-123456 then Subject will be File number W1234-123456
Message: “File number “Range(Cells(Target.Row, 1)” will be taken off the system at 02:00 PM.”
Note: The “Range(Cells(Target.Row, 1)” will trigger what is in my Column A vs. that date that is triggered and add it after File number.
Nothing online that I have found…
Thank you so much for all you geniuses :D