Mail sending from Excel

Hi Guys,

Hope you all having a wonderfull day.
I have an attached sheet on this thread , which i use this for sending large emails out, just to make mylife easier.
Now what i am trying to do is that, on Promotion sheet I have designed a promotion page. what i want is now.
Macro to copy data from promotion sheet (including images and formats) and paste it on to Body of the mail ( Please see picture the way i wish it to work)
I had to minimize the size of the file due to limitation of Excel forum. so in order for macro work you need to save the file as xlsm format.

Thank you all in advance

Greetings
Ben

Anyone Guys?

Ron De bruins website has the instructions that you need to build your mail package, you will need to use the HTML demonstrations to build the page as you want it.
www.rondebruin.nl/sendmail.htm

regards,

Iain