+ Reply to Thread
Results 1 to 2 of 2

how to use .RecurrenceType item in VBA while sending outlook appointments

  1. #1
    Forum Contributor
    Join Date
    11-01-2016
    Location
    Prague
    MS-Off Ver
    2013
    Posts
    121

    how to use .RecurrenceType item in VBA while sending outlook appointments

    Hello,

    I have below code which is sending outlook appointment items without any error. But the problem is, sending as Daily recurrence in stead of Yearly.

    But I am using .RecurrenceType = olRecursYearNth code, I couldnt understand why its sending as Daily.

    Could you please advise?

    PS: Outcome and code is as below.

    Capture.JPG

    Please Login or Register  to view this content.
    Thanks
    Orhan

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: how to use .RecurrenceType item in VBA while sending outlook appointments

    Is this Excel code? Looks like Access code to me...

    At any rate, I believe you need to set DayOfWeekMask property (it specifies which day of the week appointment occurs).
    As well, the Instance property to specify Nth occurence of the DayOfWeekMask. During specified month of the yearly patter.

    You can find sample code in link below.
    https://docs.microsoft.com/en-us/off...RecurrenceType
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Outlook Calendar Appointments
    By ryan.wherry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2016, 04:10 AM
  2. Outlook appointments VBA
    By sara1989 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2015, 07:26 AM
  3. [SOLVED] Calendar appointments in Outlook via VBA
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-15-2013, 08:11 AM
  4. Excel VBA and Outlook appointments
    By Ironman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2011, 12:00 PM
  5. Help With userForm and outlook appointments
    By gmc2k2 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-11-2011, 11:23 AM
  6. appointments in Outlook from Excel
    By each in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2007, 08:11 AM
  7. get Outlook calcendar appointments
    By gabch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2006, 05:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1