Macro to email HTML formatted mail merge from list in excel

Hi,
What I would like is a macro to send an email from outlook to each person from a list in excel. The table would look like this:

No.	Name	Email
1	name1	email 1
2	name2	email 2
3	name3	email 3
4	name4	email 4

This list would vary in size so excel should stop when it gets to a blank cell.

The email would preferably be saved in a folder in outlook called Templates (or in the Drafts folder). It would read something like this:

{name}, thank you for your support
{Order Number}

The email must be in HTML format as the email will contain images in the body of the email.

I have a macro (attached) that works perfectly, but the images in the body of the email appear as a red cross even when I press download images.

Any help would be greatly appreciated.

Thanks