Excel VBA Compile error: User-defined type not defined

Question

I want the Excel VBA code to automatically send me reminders about contacting clients when next deadline comes

Other things seem to work but it does not send me the mail as intended and give me a Compile Error

Here is the code:

Sub datesexcelvba() <- (and here)

Dim myApp As Outlook.Application <- (problem is here)

Dim mymail As Outlook.MailItem

Dim mydate1 As Date

Dim mydate2 As Long

Dim datetoday1 As Date

Dim datetoday2 As Long

Dim x As Long

lastrow = Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row

For x = 2 To lastrow

mydate1 = Cells(x, 12).Value

mydate2 = mydate1

Cells(x, 15).Value = mydate2

datetoday1 = Date

datetoday2 = datetoday1

Cells(x, 16).Value = datetoday

If mydate2 - datetoday2 = 0 Then

Set myApp = New Outlook.Application

Set mymail = myApp.CreateItem(olMailItem)

mymail.To = Cells(x, 11).Value

With mymail

.Subject = "Reminder"

.Body = Cells(x, 20).Text

.Display

'.send

End With

Cells(x, 13) = "Reminder sent"

Cells(x, 13).Interior.ColorIndex = 46

Cells(x, 13).Font.ColorIndex = 2

Cells(x, 13).Font.Bold = True

Cells(x, 14).Value = mydate2 - datetoday2

End If

Next

Set myApp = Nothing

Set mymail = Nothing

End Sub

Answer 1

In the Visual Basic Editor, select Tools > References...

1. Make sure that there is no reference whose check box is ticked and whose name starts with MISSING. IF there are such, clear their check boxes.
2. Make sure that the check box of Microsoft Outlook 16.0 Object Library is ticked.

Answer 2

I do not clearly understand what is meant under point 1). 

Microsoft Outlook 16.0 Object Library is ticked. (see attachment below)

Answer 3

That is the Microsoft Office 16.0 Object Library. Please scroll down the list and tick the check box for Microsoft Outlook 16.0 Object Library.

PS you use a variable datetoday that has not been declared, nor have you assigned a value to it. Shouldn't that be datetoday1 (or datetoday2)?

Answer 4

Ahh okay, similar names. My bad. 

It seems to work now.

Is it possible to make it run the macro automatically once at 8 pm every day? When computer is in sleep mode but the excel table is still open.

Answer 5

You'd have to create a scheduled task in Windows that is allowed to wake the computer. I hope someone else can help you with that.