Macro to Extract reminder dates into Outlook calender

  • I have a spreadsheet containing reminder dates to renew certificates 21 working days before these are due, excluding weekends


    I would like a macro to export these to Outlook Calendar and to update the Outlook Calendar



    I have attached a sample of my workbook




    I have also posted on Windowsecrets Website two days ago http://windowssecrets.com/foru…ates-into-Outlok-calender




    It would be appreciated if someone could kindly assist me

  • Re: Macro to Extract reminder dates into Outlook calender


    by Diane Poremsky
    http://www.slipstick.com/devel…ntments-spreadsheet-data/


  • Re: Macro to Extract reminder dates into Outlook calender


    Thanks for the code much appreciated


    I have tried to use the code and get a compile error and the code below is highlighted


    Code
    Dim olApp As Outlook.Application




    I only amended Sheets("Sheet1").Select to Sheets("Outlook reminder").Select


    It would be appreciated if could amend the code and advise

  • Re: Macro to Extract reminder dates into Outlook calender


    Use the Tools/References menu to add a reference to Outlook, or change the code to use Late Binding (Rather more complicated).

  • Re: Macro to Extract reminder dates into Outlook calender


    Thanks for the help. I have added the reference to outlook using the Tools/references menu. When running the macro, I get "the attempted operation failed. An object could not be found" and the code below is highlighted


    Code
    Set subFolder = CalFolder.Folders(arrCal)


    It would be appreciated if you could kindly assist me in resolving this

  • Re: Macro to Extract reminder dates into Outlook calender


    This is basic debugging - see this... What is the value of arrCal and is there a folder in the Calendar folder with that name?

  • Re: Macro to Extract reminder dates into Outlook calender


    Thanks for the reply. I created sub folder names in the calendar and code now works perfectly

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!