been too busy for the MVP stuff i'm afraid :(

best regards
Patrick

"Ron de Bruin" wrote:

Hi Patrick

Long time ago that I see you post

Have you try
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm


--

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


"Patrick Molloy" wrote in message
...
if it helps, here's my code:

With OutMail
.To = "Molloy, Patrick"

If .To < "" Then
.Subject = "test charts and tables"
.Attachments.Add Environ$("temp") & "\chart1.gif"
.Attachments.Add Environ$("temp") & "\chart2.gif"

' this by itself shows the two charts in the mail
' html = "<body<div<img src='chart1.gif'/<img
src='chart2.gif'/</div" ' & Replace(SaveTable, "<body", "")

'this by utsefl shows the tables in the mail
html = SaveTable ' this is an excel sheet saved
' as html read back as a text file

.HTMLBody = html

.Save
.Display
End If

End With




"Patrick Molloy" wrote:

I have an Excel workbook that runs some vba which generates about 20 tables
and
charts, saving then charts as .gif files

I need to mail some of these tables with their charts , and show them in
html format in the mail body

I have been able to either show all the charts OR show all the tables, but i
haven't been able to show both

I cannot use the excel envelope method.

any suggestions would be appreciated.
I also asked this question in the Outlook.Programming news group - i hate
cross-posting too - apologies

thanks
Patrick