+ Reply to Thread
Results 1 to 5 of 5

VBA Recurring Task

Hybrid View

  1. #1
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: VBA Recurring Task

    RecurrenceType is not a property of the mail item, it's a property of the recurrencepattern. So I think you need
    .GetRecurrencePattern.RecurrenceType = olRecurs Weekly
    I'm not 100% sure that works, you might need to set an object to the recurrence pattern and then change it, the help file says:
    Set myItem = Application.CreateItem(3)
    Set myPattern = myItem.GetRecurrencePattern
    myPattern.RecurrenceType = 2
    myPattern.Regenerate = True
    myPattern.Interval = 3
    myItem.Subject = "Oil Change"
    myItem.Save
    myItem.Display

  2. #2
    Forum Contributor
    Join Date
    05-26-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    682

    Re: VBA Recurring Task

    Hi yudlugar, thank you for taking the time to reply to my psot with code.

    I did try your intital suggestion, and as you suspected, this created the same error.

    I too, had looked at the help you've kindly highlighted, but I just wasn't sure how to amend this to suit my needs.

    Many thanks and kind regards

+ 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. Recurring Task / Delayed Email in Outlook 2010
    By sme001 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 03-12-2013, 11:41 AM
  2. VBA Excel/Email Recurring Task help!
    By jsabo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2012, 05:55 PM
  3. [SOLVED] IF contingent task closed, THEN change formatting of dependent task cell
    By tek_9 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-29-2012, 08:40 PM
  4. Previous Task and Next Task buttons aren't working
    By top.C.Crets in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2012, 08:27 AM
  5. [SOLVED] dialog box for active cell task to speed repeditive task
    By Todd F. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2005, 10:05 AM

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