how do i set up a repeating meeting in outlook?
 

how do i set up a repeating meeting in outlook?
 

Firstly, you'd be better asking in an Outlook group, not an Excel group.
Secondly, please put the question in the body of the message, not just in
the subject line.
[And thirdly, Outlook help will give you the answer.]
--
David Biddulph

"Naomi x" <Naomi wrote in message
...

how do i set up a repeating meeting in outlook?
 

I adapted some code from MSDN Library:

Sub RecurringYearNth()
Dim objOutlook As Outlook.Application

Set objOutlook = GetObject(, _
"Outlook.Application")

Dim oAppt As Outlook.AppointmentItem
Dim oPattern As Outlook.RecurrencePattern
Set oAppt = objOutlook.CreateItem(olAppointmentItem)
Set oPattern = oAppt.GetRecurrencePattern
With oPattern
.RecurrenceType = olRecursYearNth
.DayOfWeekMask = olMonday
.MonthOfYear = 6
.Instance = 1
.Occurrences = 10
.Duration = 180
.PatternStartDate = #6/1/2007#
.StartTime = #2:00:00 PM#
.EndTime = #5:00:00 PM#
End With
oAppt.Subject = "Recurring YearNth Appointment"
oAppt.Save
End Sub

On Nov 12, 9:44 am, Naomi x <Naomi
wrote: