Dear All Excel Experts...I need your immediate help...its been years together I am not getting any help on Lotus Calendar and excel integration..
I am working on a MOM. MOM have certain items need to be completed by certain dates. Many of the times I miss the action item deadline. I wish to create a macro which will read the cell value ie DATE by which task has to be completed. After reading the date value, macro should be able to create a reminder in Lotus notes 9. I should get the reminders on or before the actual event occurrence date. IF there are multiple items with same or different completion dates, for all those events there should be a individual reminder.
Please help.....
I am working on a MOM. MOM have certain items need to be completed by certain dates. Many of the times I miss the action item deadline. I wish to create a macro which will read the cell value ie DATE by which task has to be completed. After reading the date value, macro should be able to create a reminder in Lotus notes 9. I should get the reminders on or before the actual event occurrence date. IF there are multiple items with same or different completion dates, for all those events there should be a individual reminder.
Please help.....