Tasks from Excel sheet in Outlook VBA

[Thoro]

Hi there!

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.

Thank you in advance!

 

[Thoro]

I have already resolved the problem with structuring my data into a decent form ready to be uploaded to Outlook.

Is there any possibility to upload the list like attached using VBA instead of Import or Export Wizard?

Thanks!