Outlook Appointment recurrence setting

Status
Not open for further replies.
J

JP Ronse

Hi All,

I am working on an automation project to send recurrent meeting requests

from an Excel file on.

Everything works fine for weekly, monthly and monthNth recurrent meetings.

Also daily recurrent meetings are OK but the thing I don't see is how to

specify that 'every weekday' option has to be used. I'm usiing Office/Oulook

2003.

Part of my code:

Select Case golRecurrenceInfo_Occurence

Case olRecursDaily

olRecurrencePattern.RecurrenceType = olRecursDaily

olRecurrencePattern.Interval =

golRecurrenceInfo.Interval

Case olRecursWeekly

olRecurrencePattern.RecurrenceType = olRecursWeekly

olRecurrencePattern.Interval =

golRecurrenceInfo.Interval

golRecurrenceInfo.Interval is an intenal variable containing the recurrency

info. I would be grateful for any help.

Wkr,

JP
 
J

JP Ronse

Hi Michael,

Thanks for your help. You are right. Meanwhile I was able to figure out that

I had to use 62 as DayOfWeekMask to point to every weekday (Mon to Fri).

Wkr,

JP

 
J

JP Ronse

Hi Dimitry,

Thanks for your help. Indeed it is 62. I was able to figure it out with some

other code I have already in use.

If I had a look to all constants and not only to olSunday & olMonday, I

would have seen that Sun =1, Mon =2... Sat =64 and not the usual values 1 to

7.

Wkr,

JP
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M using excel to sort outlook appointment items Outlook VBA and Custom Forms 4
S New Outlook Appointment - Select All Body Text and Change Font and Size Outlook VBA and Custom Forms 1
W Space in an Outlook appointment body Using Outlook 0
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
Diane Poremsky Create an Outlook appointment from an email message Using Outlook 4
N Adding Appointment Item in Outlook to Shared Calendar Folder Outlook VBA and Custom Forms 7
J Outlook calendar...How to add an event or appointment without a border around it? Using Outlook 9
F Outlook 2010 Search Appointment Notes Using Outlook 0
Tech Checkers Make Outlook add Contact Card Address in Location Field based on Appointment Subject Name. Using Outlook 2
K Importing appointment body from excel in outlook 2010 Using Outlook 1
M Outlook appointment in asp.classic Using Outlook 2
L Showing @live account in outlook 2013 calendar as private appointment Using Outlook 1
A iCloud add-on for Outlook: Reminder for new appointment is set to 'None' by default. How to change? Using Outlook 6
J Outlook 2010: can't forward appointment on custom form Using Outlook 1
Rijotech Outlook 2013 Appointment list custom positions? Using Outlook 2
R How to copy outlook 2010 shared calendar appointment or meeting to personal calendar by vba? Outlook VBA and Custom Forms 1
R Static Resources in Custom Outlook Appointment Form Using Outlook 2
L Outlook 2007 Code for Note Fields of Appointment Using Outlook 102
M Outlook Appointment Item exceeds beyond the date range Using Outlook 2
S Calendar deletes appointment after entry from both Outlook and Icloud calander Using Outlook 1
M Outlook Appointment item does not show the item outside the date range Using Outlook 2
H Reocurring outlook appointment (office 2010) does not update Outlook.com Using Outlook 3
C Outlook Appointment issue when synchronized with iCloud 2 Using Outlook 8
M "New Appointment from Contact" command missing from Outlook 2003 Using Outlook 1
B Outlook Calendar Appointment Problem Using Outlook 1
O Rescheduling appointment on Outlook 2010 for Windows creates duplicate entry Using Outlook 2
T Outlook makes every appointment recurring and set to the current date/time Using Outlook 2
P Create appointment to custom (shared) outlook calendar Outlook VBA and Custom Forms 3
S Custom Form overwriting the default appointment form in outlook 20 Outlook VBA and Custom Forms 1
Q How outlook Store Appointment Outlook VBA and Custom Forms 1
Retired Geek Outlook for the MAC with Yahoo accounts now very broken Using Outlook 6
S Outlook 2002- "Send" button has disappeared. Help please. Using Outlook 1
L How Stop Outlook Nag Messages Using Outlook 1
TomHuckstep Remove Send/Receive All Folders (IMAP/POP) button from Outlook 365 Ribbon Using Outlook 1
L I Cannot Sign Into My Outlook Account? Outlook VBA and Custom Forms 0
icacream Outlook 2021 - Google calendar in the peek Using Outlook 0
e_a_g_l_e_p_i Question about installing my Gmail account on my iPhone but still getting messages downloaded to my desktop Outlook. Using Outlook 3
F Want to add second email to Outlook for business use Using Outlook 5
kburrows Outlook Email Body Text Disappears/Overlaps, Folders Switch Around when You Hover, Excel Opens Randomly and Runs in the Background - Profile Corrupt? Using Outlook 0
e_a_g_l_e_p_i MY Outlook 2021 changed the format of the shortcuts for mail, calendar etc. Using Outlook 10
Z Outlook 2021 Outlook new emails notification not working Using Outlook 5
K Changing the Deleted Items location in Outlook 2019 Using Outlook 2
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
V How to use Comas in a picklist in Outlook forms Outlook VBA and Custom Forms 3
e_a_g_l_e_p_i Question about reinstalling Outlook 2021 Using Outlook 5
A Outlook 365 Outlook (part of 365) now working offline - argh Using Outlook 5
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
G LinkedIn tab missing in Outlook 365 (but working in OWA) Using Outlook 0
Jay Freedman Outlook forgets "not junk" marking Using Outlook 0
KurtLass Opening Graphics Attachments in Outlook 2021 Using Outlook 0

Similar threads

Top