Sending reminders in Outlook from a date field in Excel

I have seen previous threads regarding this but I am still struggling with it.

Can somebody please tell me where I need to put the code below, and also, do I need the Excel spreadsheet open at the time for the Reminder to be sent?

Sub CreateTasks()

Dim olApp As Object
Dim olTask As Object
Dim LastRow As Long
Dim i As Long

Set olApp = CreateObject("Outlook.Application")

LastRow = Cells(Rows.Count, "C").End(xlUp).Row

For i = 2 To LastRow
If Cells(i, "C").Value <> "" Then
Set olTask = olApp.CreateItem(3) 'olTaskItem
With olTask
.Subject = "Invoice - " & Cells(i, "B").Value
.Body = "Reminder for Maturity in " & Cells(i, "B").Value & "."
.Status = 1 'olTaskInProgress
.Importance = 2 'olImportanceHigh
.DueDate = Cells(i, "C").Value
.ReminderSet = True
.ReminderTime = Cells(i, "C").Value + TimeValue("08:45:00")
.Save
End With
End If
Next i

End Sub

Assuming that you have open an XL worksheet on which this code can operate...

Hit ALT+F11 to open the VBA code editor, paste code, hit F5 to run the code. Should work.

The reminders will be created in Outlook so you do not need to have the spreadsheet open for them to fire; you should be able to see the reminders in your Outlook by looking at your Tasks.

Will give this a go

many Thanks

This has done the job

If I add data to another sheet in similar format will the code know to ignore it?