SOLVED

Email Alerts in Excel

Copper Contributor
Just asking, do you know if it's possible to send an email alert to myself when a date is due.
 
For example, I work with calibrated devices and they have calibration due dates.
 
I enter the device description on a sheet and with the Cal data I fill out the details and place calibration date and due dates on for the next schedule.
 
I wanted to alert myself with an email, but from Excel recognising this is due and alerts me.
 
Is this possible or not, as Yes I will always close the workbook and thought can Excel do this whilst not active or when I next open the workbook would be good too.
 
Let me know if you have covered this in a video, but keep in mind I want Excel to do it for me without me always viewing my matrix for due dates.
 
Any tips or videos will help.
 
Regards
Mick 
5 Replies

@Mick 

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.

 

@NikolinoDE 

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. 

best response confirmed by Mick (Copper Contributor)
Solution

@Mick 

Mail from Excel and make...

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)
1 best response

Accepted Solutions
best response confirmed by Mick (Copper Contributor)
Solution

@Mick 

Mail from Excel and make...

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)

 

View solution in original post