Hi everyone!,

I am a newbie in VBA and macros and I am wondering if it's possible to import a tasks list from Excel to Outlook and get instant pop ups (eg. one your before the task deadline) basing on that list.

The problem is that not the whole date is in one cell.
Dates are in column A while hour of task in row 4.
The task is on the intersection of these lines (column A & row 4).

Once the task is found I would like to assign it as task with the appropriate date and time in Outlook to get automatically pop ups.


Could anyone can help me how to figure it out? Attached the sheet with tasks.​

Capture.JPG

Thank you in advance!​​​