Macro that Email different html template with image Header and Footer

[noelpahati10]

Serial	Activation	Request Code	Email	Type
12345	54321d	ASD432	emailname1@gmail.com	A
54321	12345c	QWE567	emailname2@gmail.com	B
67890	1q2er3	124WER	emailname3@gmail.com	C
80767	t56yt4	BVC123	emailname4@gmail.com	D

<tbody>
</tbody>

Any one knows how to make a macro that will send email to all email listed on the table.
then create a html template depending on its Type?
the template header and footer has image on it ty.

 

[noelpahati10]

Output example

Hi Mr. Excel

Just want to give you the following details:

Serial : 12345
Activation: 546321d
Request Code: ASD432

Regards,
Member