Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need function that will work in Excel 2003 like "Countifs" in 2007 | Excel Worksheet Functions | |||
Function dosn't work in Excel 2007 but did in 2003 | Excel Worksheet Functions | |||
HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming | |||
Jim Rech's macro won't work (autofitting merged cells) | Excel Discussion (Misc queries) | |||
Jim Rech's Browse for Folder | Excel Programming |