VBA Excel creating Outlook Email

Hello,

I have been really struggling with this. Advice would be much appreciated. I have been looking a lot at Ron de Bruin's website but I am still unclear.

Here is my code:-

Please Login or Register  to view this content.

The problems I have are:-

1.) I want the body of the email to be a defined range from excel. But I cannot get it to work. In the case above the defined range in excel is called Holding

2.) How do I get my email signature to be added to the message? I seemed to have accidentally done this in previous trials of mine, but I am very unclear.

Many thanks

Thanks for your help. To be honest after looking at all that it might be easier to do it another way.

Thanks though