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:

[TABLE="width: 65"]
<tbody>[TR]
[TD]CC-1613[/TD]
[/TR]
[TR]
[TD]CC-1612[/TD]
[/TR]
[TR]
[TD]CC-1605[/TD]
[/TR]
[TR]
[TD]CC-1560[/TD]
[/TR]
</tbody>[/TABLE]




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




Thank you