Publishing XCL Range to HTML to insert into Email Body

J

JingleRock

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
 
R

Ron de Bruin

Hi JingleRock

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top