Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 ... |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i se up a repeating meeting in outlook? | Charts and Charting in Excel | |||
custimized outlook today in outlook 2007 | Excel Discussion (Misc queries) | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
How do you set up a repeating column in Outlook? | Excel Discussion (Misc queries) | |||
Outlook 2003 demo back to Outlook XP | Excel Discussion (Misc queries) |