Macro that Email different html template with image Header and Footer

[noelpahati10]

[TABLE="width: 100"]
<tbody>[TR]
[TD]Serial[/TD]
[TD]Activation[/TD]
[TD]Request Code[/TD]
[TD]Email[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]54321d[/TD]
[TD]ASD432[/TD]
[TD]emailname1@gmail.com[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]54321[/TD]
[TD]12345c[/TD]
[TD]QWE567[/TD]
[TD]emailname2@gmail.com[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]67890[/TD]
[TD]1q2er3[/TD]
[TD]124WER[/TD]
[TD]emailname3@gmail.com[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]80767[/TD]
[TD]t56yt4[/TD]
[TD]BVC123[/TD]
[TD]emailname4@gmail.com[/TD]
[TD]D[/TD]
[/TR]
</tbody>[/TABLE]

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