This can be done only through macro. It is possible to set a reminder date to outlook via excel. Below is a sample code that you can try to run in your Excel file. I hope this will work.
Code:
Sub Outlook_Appointment()
Dim olApp As Outlook.Application
Dim olAppItem As Outlook.AppointmentItem
Set olApp = GetObject("", "Outlook.Application")
Set olAppItem = olApp.CreateItem(olAppointmentItem)
With olAppItem
.Start = Range("'Out_App'!A6").Value
.Subject = Range("'Out_App'!B6").Value
.Duration = 1
.ReminderSet = True
.Save
End With
End Sub
Bookmarks