VBA toggle Outlook '03 Word email editor on/off Options (continued)

[JingleRock]

For some reason (I cleaned out my memory cache), I cannot reply to the
above thread. So, I am making this a "new" post.

I have a different experience.

I used Ron's code to publish an Excel sheet range to HTML and then use
the HTML range as the body of an email. The only thing different that
I did was to control my Excel coding from Outlook VBA; since my
project is triggered by receipt of a specific email. I am using
Office 2003.

I read Ron's warning about using Word as your email editor. However,
I am getting exactly the same results when using Word as editor and
when not using Word as editor; and those results are generally very
favorable. The only slight glitch is that, at the top of the email
body window, I am getting about 2 1/2 blank lines (using the height of
the first row of HTML as a benchmark). Does anyone know the cause?

P.S.: I read Ron's Word warning to apply only to, in the email body,
creating non-HTML rows of text directly above the HTML and not to
sending emails with HTML in the body.

Ron, are you out there?

JingleRock

 

[Ken Slovak - [MVP - Outlook]]

Ron who? If this refers to Ron DeBruin you probably should post your
question in one of the Excel groups he posts in.

 

[JingleRock]

Ken,

Thanks for responding.
The main gist of this thread has to do with Outlook VBA and issues
concerning whether Word has to be de-selected as the Email Editor. It
just so happens that the first post referred to Ron's code. My
primary concern is with Outlook VBA at this point.

JingleRock

P.S.: Ron has several posts in this Group as well.