Ron when i use that code i get a compile error.
Sub or Function not defined.
the code its pointing too is:
.HTMLBody = SheetToHTML(ActiveSheet)
it does not like the "SheetToHTML(ActiveSheet)" part.
am i missing a refenrence perhaps?
You miss the function that is on the webpage
Copy it also in the module
Like this
Sub Mail_ActiveSheet_Body()
Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail
.To = "ron@debruin.nl"
.CC = ""
.BCC = ""
.Subject = "This is the Subject line"
.HTMLBody = SheetToHTML(ActiveSheet)
.Send 'or use .Display
End With
Application.ScreenUpdating = True
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
Public Function SheetToHTML(sh As Worksheet)
'Function from Dick Kusleika his site
'http://www.dicks-clicks.com/excel/sheettohtml.htm
'Changed by Ron de Bruin 04-Nov-2003
Dim TempFile As String
Dim Nwb As Workbook
Dim myshape As Shape
Dim fso As Object
Dim ts As Object
sh.Copy
Set Nwb = ActiveWorkbook
For Each myshape In Nwb.Sheets(1).Shapes
myshape.Delete
Next
TempFile = Environ$("temp") & "/" & _
Format(Now, "dd-mm-yy h-mm-ss") & ".htm"
Nwb.SaveAs TempFile, xlHtml
Nwb.Close False
Set fso = CreateObject("Scripting.FileSystemObject")
Set ts = fso.GetFile(TempFile).OpenAsTextStream(1, -2)
SheetToHTML = ts.ReadAll
ts.Close
Set ts = Nothing
Set fso = Nothing
Set Nwb = Nothing
Kill TempFile
End Function

Signature
Regards Ron de Bruin
http://www.rondebruin.nl
> Ron when i use that code i get a compile error.
>
[quoted text clipped - 7 lines]
>
> am i missing a refenrence perhaps?
sungen99 - 26 Jan 2006 18:19 GMT
AHHHHHHHHHH THANK YOU!!!!!!
i understand. been working on this for 4 hours now.. hehe.
Ron de Bruin - 26 Jan 2006 18:25 GMT
Hi sungen99
Instead of
.HTMLBody = SheetToHTML(ActiveSheet)
You can also use this
.HTMLBody = SheetToHTML(Sheets("YourSheetName"))

Signature
Regards Ron de Bruin
http://www.rondebruin.nl
> AHHHHHHHHHH THANK YOU!!!!!!
>
> i understand. been working on this for 4 hours now.. hehe..