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.
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