How to do Reminder Date from xls to Outlook calendar

[stavar]

Hi folks,
I need a little help how to have reminder date from Excel xls into Outlook calendar.
It might be simple but our office IT guys couldn’t figure out so I need some help... I created a sample xls file with proper columns – attached. I am not a programmer so I am trying to figure out how to have automatic reminders 3 days before the “Start Date” which will be different for each item and there will be thousands of items on this list.

I appreciate your help.
Thanks

[BillieJ]

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.

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