|
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 |
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 |
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 |
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 |
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 |
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 |
html chart and table in outlook mail
Hi Patrick
Sorry I not know a way to display a mail with pictures like you want Why not send it as a PDF ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Patrick Molloy" wrote in message ... 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 |
| All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com