Connection With Outlook

  • Hello


    This is my first post here, and hope I don't make it wrong.


    My request is relatively simple:
    In a sheet containing date and comment, I would like to put a link/button to allow reader to insert the information directly in the Outlook Calendar and create a reminder.


    Example:
    in column A , I have the date
    in column B , I have the hour
    in column C , I have the comment ("remember to check account")
    in column D , the button


    When the user click on the button, an entry should be created in Outlook calendar at the date and time from column A and B, with the comment from C and an alarm one hour or one day before.


    I think dynamically create a vCal file but it's seems a little bit complex and may be there is a better solution ....


    Thanks in advance for your help


    ericc