Creating yearly recurrence appointment

Not open for further replies.


i am creating recurring appointments from my code..

i am following help file from vba editor

every thing working perfectly

except when i select my recuuring pattern

Yearly January 3rd for 10 occurances and start date is today(ie: 10/15/2009)

i am giving like bellow

recurrencePattern.RecurrenceType = Microsoft.Office.Interop.Outlook.


recurrencePattern.DayOfMonth = 3;

recurrencePattern.MonthOfYear = 1;

means it sholud start from janudary 3rd 2010

but it is not certaing on january..

it is creating on october 3rd

please help me
and i want to create daily Evry weekday, how can v set every week day , if v


Interval then it sets daily

how can we set "DayOfWeekMask"

when i set like this

recurrencePattern.DayOfWeekMask = Microsoft.

Office.Interop.Outlook.OlDaysOfWeek.olMonday | Microsoft.Office.Interop.

Outlook.OlDaysOfWeek.olTuesday | Microsoft.Office.Interop.Outlook.

OlDaysOfWeek.olWednesday | Microsoft.Office.Interop.Outlook.OlDaysOfWeek.

olThursday | Microsoft.Office.Interop.Outlook.OlDaysOfWeek.olFriday;

it is giving error

please help me
If you look at the VBA Help on the MonthOfYear property you will see that

setting it to 1 wouldn't mean the recurrence starts in January, it means

that it should only recur every January. However, that can be changed or

overridden by other settings you make and the order in which they are set.

If I wanted a yearly recurrence starting on January 3, 2010 I'd set the

StartTime to January 3 at a specific time and set a yearly recurrence.

So, in pseudocode:

set recurrence type to yearly

set recurrence start to January 3, 2010

set occurrences to 10

Because you often find that the actual pattern generated from settings in

the UI dialog don't match I've found the best way to handle things if I have

questions is to create an actual dummy recurring appointment with the

pattern I want in the UI dialog, then I analyze the resulting

RecurrencePattern on the recurring series to see how Outlook interpreted the

pattern I wanted.
Are you setting the recurrence type to recurs weekly first? Then you OR the

days you want into the mask you set. To make things easier to debug I derive

the OR'd value first and then set that result for the DayOfWeekMask


Thanks for your support

i am setting the recurrence type to recurs daily and i am setting

recurrencePattern.DayOfWeekMask = (Microsoft.Office.Interop.Outlook.


then it is giving bellow error

"The property for the recurrence type is not valid. Verify your code."

if i set weekly and dayofmask it is working properly but when i recurrence

pattern there weekly type and week days checkbox is selecting but i want to

select daily and weekday options

You have to use code that works, not what you'd like to use. If those are

the settings you want you have to use the weekly type with the day of the

week mask set. Otherwise it won't work.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 6
S Custom Contact card - need help creating one Outlook VBA and Custom Forms 1
D Outlook 2016 Creating an outlook Macro to select and approve Outlook VBA and Custom Forms 0
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
G Event when creating task from mailitem Outlook VBA and Custom Forms 2
T Outlook creating unwanted tasks in Tasks and Todo from emails Using Outlook 1
Fozzie Bear Outlook 2016 Creating a shared local Contacts folder Using Outlook 2
R Creating a user defined function Outlook VBA and Custom Forms 3
M Creating an RSS Feed **FROM** Outlook 2013 Calendar. Using Outlook 5
O How to prevent CC from showing when creating a new mail? Using Outlook 1
N Creating a button or link to a form in the Organizational Forms Library Outlook VBA and Custom Forms 3
B Creating an email with the list of tasks Outlook VBA and Custom Forms 0
L Creating drafts when I thought I was sending Using Outlook 1
R Would creating a new profile cause Outlook to download all the old mails from the server? Using Outlook 1
A Creating Progress Bar or Status Bar Update Outlook VBA and Custom Forms 0
T Outlook creating a folder named: "Unwanted" Using Outlook 3
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
Liza Creating a rule in outlook to filter messages Using Outlook 0
A Are categories still recommended for creating local distribution lists? Using Outlook 3
S Creating Email - Selecting Pre-Defined Text Using Outlook 2
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
M Creating Outlook Appointments from Excel Cells Outlook VBA and Custom Forms 1
N Creating New Profile Using Outlook 0
Y Creating custom appointment request form with multiple mail recipients Outlook VBA and Custom Forms 5
M creating email from contact file = 3 emails in To field Using Outlook 3
P Recover / Extract Rules from standalone PST file creating RWZ file Using Outlook 2
A Creating an outlook rule to forward an email with a specific message Using Outlook 1
I Creating meeting invite with disabled tentative button Outlook VBA and Custom Forms 5
E Creating email templates for organizational use Using Outlook 0
N Creating or changing the main new mail message template in Outlook 2010 Using Outlook 2
D Creating custom view with VBA Outlook VBA and Custom Forms 2
J Outlook creating unwanted rule on its own Using Outlook 1
R Creating a Room Mailbox with Exchange Online Outlook VBA and Custom Forms 0
A Creating a rule on “Deleted items” folder Using Outlook 1
CMG73 Creating templates with predefined subject and CC Using Outlook 1
G Creating Contact Sub Folders Using Outlook 2
Rupert Dragwater creating gmail account in Outlook 2013 Using Outlook 7
nathandavies Creating a Select Case for a directory of folders Outlook VBA and Custom Forms 1
2 creating custom stationery Using Outlook 2
A Help creating macro for conditional formatting settings Using Outlook 8
Fozzie Bear Creating Custom Meeting Form Outlook VBA and Custom Forms 6
U Creating a (This computer only) folder within an IMAP account directory Using Outlook 1
A Creating archive rule on the clients by script/ Outlook VBA and Custom Forms 3
J Creating a URL from a message body excerpt before forwarding Using Outlook 2
B Need Help Creating Email Based on Subject w Address in Body Outlook VBA and Custom Forms 1
A Creating rule to create week folder and transfer mail using alert Using Outlook 3
J Creating an "isolated" shared calendar in Outlook Outlook VBA and Custom Forms 1
L Creating a Task from Email and Attaching Original Email Outlook VBA and Custom Forms 6
S Creating custom rule to move if "NAME" is in body but ignore the phrase "Hi NAME" in the search Using Outlook 2
Witzker Outlook bug when creating a user defined contact form? Using Outlook 1

Similar threads