View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Publishing XCL Range to HTML to insert into Email Body

Hi JingleRock

You can send me your test code private and I try to look at it this weekend



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"JingleRock" wrote in message ...
I used Ron De Bruin's code to publish an Excel sheet range to HTML and
then used
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 MS 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