Adding Excel Range in Outlook Message Body

[Excel313]

Hi guys,

I need to extract a range of cells from Excel and mail it by adding it to Outlook Message Body. The code needs to be run from Excel, not Outlook. I have actually managed to do so using the inbuilt MailEnvelope property of Excel but it shows the undesired warning that Outlook is being called by an external program..

I had earlier used Redemption Library to get around this problem, but for another code using the plain old VBA. (I had sent Excel worksheet as an attachment.) I tried re-using the same code - adding the Excel Range to the Message Body (HTMLBody) - but it didnt work.

What would be the best approach to go forward with? Any suggestions would be welcome...

 

[vconfused]

I've used the Click Yes programmatically before (http://www.contextmagic.com/express-clickyes/)...

 

[SydneyGeek]

This page has heaps of stuff. Take a look.

Denis

 

[Excel313]

Hi vconfused, thanks for the suggestion. However, I am not looking for a third-party software to do the job for me...

Many thanks SydneyGeek, I got what i wanted...