Have you try my code ?
http://www.rondebruin.nl/mail/folder3/mail2.htm

--

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


"JeffreyW" wrote in message ...
After searching around the web, I havent found any solution that allows me
to use Jim Rech's SheetToHTML function discussed at (amongst other places):

http://www.dicks-clicks.com/excel/ol...ingExceltoHTML

€¦ to generate an Outlook email from Excel 2007. The code I used, adapted
from these suggestions, works fine in Excel 2003 (even when output is to
Outlook 2007), but when run from Excel 2007, it produces an email with the
message "This page uses frames, but your browser doesn't support them".

The code I use copies the contents of a sheet in an Add-in file, saves it to
a temporary HTML file and generates that content within the body of the
Outlook email (at least it does from Excel 2003 €“ in Excel 2007, I get the
above message). I compared the HTML output from both 2007 and 2003. The
HTML was drastically different between the two versions with 364 lines of
code produced in 2007 vs. 164 in 2003. While I am not sure that is relevant,
I suspect the way Excel 2007 generates its HTML is a factor here.

Does anyone have any suggestions I might pursue to resolve this issue?

Thanks,

Jeff