VBA create emails based on content

[crumbcounter]

I run a macro that returns a table similar to below. These are change control tickets that need to be approved by 4 managers (APPDev, Help Desk, etc). From this table I would like to run a macro sending a single email to each manager listing the specific ticket number(s) that need to be approved.

Ideally the email would say

Hello Bobby (appdev manager).

Please review the following tickets:

CC-1613

CC-1612

CC-1605

CC-1560

<tbody>
</tbody>

Key	Summary	Status	Assignee	Due Date	Approved by AppDev	Approved by Help Desk	Approved by IT Services	Approved by Infrastructure
CC-1613	Phasing out of ATLPRT01, ATLFILE01 and ATLVCENTER	Scheduled	dave ratliff	11/30/2017		Yes	Yes	Yes
CC-1612	Porting DC Phone Numbers from Level 3 to Comcast	Scheduled	Unassigned	11/15/2017				Yes
CC-1605	Power Down San Francisco Nimble Storage	Scheduled	john schmidt	10/13/2017				Yes
CC-1560	DR Test	Scheduled	Ben Gallahan	09/22/2017		Yes		Yes

<tbody>
</tbody>

Thank you