Excel vba how to send a daily recurrence appointment email?

Dear all, have any way to send an daily recurrence appointment email base on today at 1pm notification period is 12 day?

.
This is one way :

Please Login or Register  to view this content.

sry, i currently using this code , it can send normal mail successfully. but how can i modify it become adding the recurrence appointment?
i am thinking to set the appointment date is date() at 1pm and notification peroid for 12 day.

Please Login or Register  to view this content.

Thanks.

.
Ok, using your code .. paste this code into a Routine Macro where your current macro is located :

Please Login or Register  to view this content.

Paste this code into the ThisWorkbook Module :

Please Login or Register  to view this content.

Take note of the comments on Sheet 1

i had attached an example,but this one notification at 1 pm for 12 day period are not working.
got any way to modify it?
Thanks!