Automatically creating a outlook task reminder 3 days before date entered in database

[seandedross]

Hi,

I am trying to create a database, where it automatically creates an outlook reminder 3 days before a date that has been entered into the form. I want the reminder to contain the text "REMINDER - Adjudication Date in 3 days time - Job Name", where the Job Name is something from another entry in the form. The email addresses that the reminder needs to be sent to are also from another entry in the form.

I've had a look around, but the only things I seem to be able to find are based on todays date, and not a specified date, and also fixed to a specific email address.

Thanks

 

[MarkK]

Hey there. Welcome to the forum.
Here's code I wrote recently that creates an Outlook reminder. I implemented this as a class called 'cOutlookReminder.'

Private m_ol As Outlook.Application
Private m_ap As Outlook.AppointmentItem

Property Get OutlookApp() As Outlook.Application
   If m_ol Is Nothing Then Set m_ol = New Outlook.Application
   Set OutlookApp = m_ol
End Property

Property Get Appointment() As Outlook.AppointmentItem
   Set Appointment = m_ap
End Property

Public Function AddNew(DateTime As Date, Subject As String, Body As String, IsAllDay As Boolean, AttachPath As String) As cOutlookReminder
   Set m_ap = Me.OutlookApp.CreateItem(olAppointmentItem)
   With m_ap
      .Subject = Subject
      .Location = Body
      .Body = Body
      .Attachments.Add AttachPath
      .Start = CStr(DateTime)
      .ReminderMinutesBeforeStart = 30
      .AllDayEvent = IsAllDay
      .ReminderSet = True
      .Save
   End With
   
   Set AddNew = Me
   
End Function

 

[atticus1802]

This sounds exactly what I am trying to achieve. However I am looking to get it to do this for mutiple fields. For example we have a securty pass expiry date, wire warden training date, first aider etc.

Where would it be a case of putting this as an event procedure for each field which has a renewal date?

 

[atticus1802]

Any update on this?

 

[MarkK]

What do you mean, "any update?" You want it customized?
Cheers,
Mark

 

[atticus1802]

This sounds exactly what I am trying to achieve. However I am looking to get it to do this for mutiple fields. For example we have a securty pass expiry date, wire warden training date, first aider etc.

Where would it be a case of putting this as an event procedure for each field which has a renewal date?

Sorry by any update I meant was there any thoughts on this?

 

[MarkK]

In the posted code you call the AddNew method, passing in the parameters it requires, to create an appointment. To create mutiple appointments, call the method multiple times.
There is no restriction on when or how you use this. Run it from a button. Run it when a form opens. Whatever. There's no right or wrong event to use or anything.
Is that what you're asking? I get a bit stuck because a field is a specific thing in database jargon and the thing I call a field does not have a renewal date.
Cheers,
Mark