Send worksheet to Outlook email by referencing a list of emails on another worksheet

Hello All,

After finding a working send worksheet to outlook vba coding (credits to the owner, thanks Mr. De Bruin), I find out it works perfectly when sending to a single recipient.

With my crude vba knowledge, I can make it also work to reference a single cell containing a single email address using range.value (Also shown below)

Please Login or Register  to view this content.

On the attachment, how can I make it that the Main body of the email sheet will be sent to Outlook using the recipients for "To:" and "CC:" which is found in worksheet "Email Listing"?

Thanks!