Send excel sheet to multiple emails according to the date and time set

Hi guys, great to be in this forum. I'm new here btw. And new to VBA as well. Need your help to guide me through my problem here. You see, my visual for this project is to send sheet/s to multiple email with different recipients respectively according to set date and time automatically. But the problem is right now my coding send multiple recipients' name to certain activated email . And also, my coding cannot read the recipient's email. will somebody here that generous and kind enough to help me? If you didn't understand what I'm babbling here you guys can refer to my macro attached. Thank you

Please Login or Register  to view this content.