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

  • Thread starter Thread starter JingleRock
  • Start date Start date
J

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
 
Ron who? If this refers to Ron DeBruin you probably should post your
question in one of the Excel groups he posts in.
 
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.
 
Back
Top