Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a repeating meeting in outlook?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |