brettdj
10-14-2004, 06:21 AM
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
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