Excel macro to send formatted (HTML) email from Lotus Notes

[jpack]

I would like to be able to have a macro to send a worksheet in my spreadsheet to a person using lotus notes. But I want to be able to keep the formatting in Excel, and insert it in a new message with out it being a pictures.

Basically, I want it to show up as a table in the new message in Lotus.

I can step through it manually... Save the worksheet in Excel as an html file, go in to Lotus, create a new mail message, file->import the created html file into the body of the mail message.

Is there some way to automate this in a macro in Excel? I have seen other macros to insert a worksheet as text, but I would really like to keep the formatting and insert as HTML, and not a picture or plain text.

Thanks,
JP

 

[jpack]

by the way...

I am using Lotus Notes v6.5 and Excel 2003

 

[pgrad]

Hi,

Did you get anywhere with this?

Thanks
Paul