A pesky little problem which has buggered me for a couple of hours.

I've written code to automate a word document and an outlook message, copy the contents of the word document to the outlook message and then send it. I'm running the code from Excel.

I want to format the outlook message as HTML but so far I've been unable to format the text and I don't want to resort to API calls to dump the clipboard contenets

I've formatted the message as
.BodyFormat = olFormatHTML
and this opens Word as my default editor

But at the moment I cant get VBA to do the same formatting job as a simple manual copy and paste

Cheers

Dave