Forum Discussion
Email Alerts in Excel
In the inserted link you will find many good suggestions for solutions in this direction.
As for Outlook, you'd have to read through the rules.
Think that it should work with the rules settings.
Take a look, if you get stuck, just give feedback and I will help you further.
If this information helped you, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Wish you a nice day
Nikolino
I know I don't know anything (Socrates)
I wonder why not using Outlook?
However you need to know it better.
Here is a small example with VBA.
Option Explicit
Sub GMG_test()
Dim lRow As Integer
Dim rngDatum As Range, c As Range
With ActiveSheet
lRow = .Cells(Rows.Count, 4).End(xlUp).Row
Set rngDatum = .Range("D4:D" & lRow)
End With
For Each c In rngDatum
If IsDate(c) Then
If c < Now Then
MsgBox ("Old date")
Call mailen
Else
MsgBox ("New date")
End If
End If
Next c
End Sub
I would be happy to know if I could help.
I wish you continued success with Excel
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
I'll look into Outlook, maybe that might be an easier option.
With the VBA code you've written, will that send me an email when due dates are approaching and not from all my sheets?
I was hoping for a video or some more detail as I'm intermediate level on Excel VBA and still learning.
Do I copy your code and paste it into the module as I have 11 sheets on this workbook and only want one sheet example sheet 4 to do this, sorry forgot to mention this earlier.
Thank you for your time and feedback Nikolino.
In the inserted link you will find many good suggestions for solutions in this direction.
As for Outlook, you'd have to read through the rules.
Think that it should work with the rules settings.
Take a look, if you get stuck, just give feedback and I will help you further.
If this information helped you, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Wish you a nice day
Nikolino
I know I don't know anything (Socrates)
- Thank you very much Nikolino for this information, you have great knowledge in this area. I have enough information to view on the link attached.
Regards
Mick- Thank you for your feedback.
For further questions I am gladly at your disposal.
Wish you a nice day
Nikolino
I know I don't know anything (Socrates)