Forum Discussion
Create Outlook meeting from Access VBA
I am the treasurer at a United Methodist Church (UMC). I would like to create an Outlook meeting based on input from an Access database form. The catch is that I would like the organizer of the mee...
I have another related question. I see that there are properties associated with a meeting that have to do with recurrence. How would I modify the code to include a recurrence of, say, the second Monday of every month until December of the current year? Jill_Marlow
Jill, you should be able to set the following items to make the meeting use a recurrence. This assumes you have already set the .Start to a 2nd Monday date. FYI the GetRecurrencePattern returns either a RecurrencePattern already setup or a blank object and then you can fill it.
Dim oRecurrence As Outlook.RecurrencePattern
Set oRecurrence = myMeeting.GetRecurrencePattern
With oRecurrence
.RecurrenceType = olRecursMonthNth
.PatternEndDate = "12/5/2022'
End With
Also see https://documentation.help/Microsoft-Outlook-Visual-Basic-Reference/olobjRecurrencePattern.htm for more info about different types of recurrence
Dim oRecurrence As Outlook.RecurrencePattern
Set oRecurrence = myMeeting.GetRecurrencePattern
With oRecurrence
.RecurrenceType = olRecursMonthNth
.PatternEndDate = "12/5/2022'
End With
Also see https://documentation.help/Microsoft-Outlook-Visual-Basic-Reference/olobjRecurrencePattern.htm for more info about different types of recurrence