| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
html chart and table in outlook mail
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
html chart and table in outlook mail
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
html chart and table in outlook mail
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
html chart and table in outlook mail
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
html chart and table in outlook mail
ha! your http://www.rondebruin.nl/mail/folder3/mail2.htm
is good - almost exactly the same code that I have too. Thats perfect for getting tables into the mail body. I need to get charts in too. How can i do that as well...so that i have BOTH charts AND tables? 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
html chart and table in outlook mail
I cannot use the excel envelope method
Why not ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Patrick Molloy" wrote in message ... ha! your http://www.rondebruin.nl/mail/folder3/mail2.htm is good - almost exactly the same code that I have too. Thats perfect for getting tables into the mail body. I need to get charts in too. How can i do that as well...so that i have BOTH charts AND tables? 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
html chart and table in outlook mail
We can't use the envelope method because the spreadsheet is fully
automated...using the mail object works sweetly because we get to see the email , using .display not .send While this is available with the envelope method, it stops the code. If we use send, we don't get a chance to see the mail. Our alternative is to use envelope an dmail to ourselves, but thats not ideal best regards "Ron de Bruin" wrote: I cannot use the excel envelope method Why not ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Patrick Molloy" wrote in message ... ha! your http://www.rondebruin.nl/mail/folder3/mail2.htm is good - almost exactly the same code that I have too. Thats perfect for getting tables into the mail body. I need to get charts in too. How can i do that as well...so that i have BOTH charts AND tables? 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert to HTML and e-mail selection as the body of the e-mail. | Excel Programming | |||
| Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
| Display mail application either in Outlook, or Outlook express | Excel Programming | |||
![Patrick Molloy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
