|
e-mail macro
I currently have a macro set up that will e-mail out different worksheets as
e-mail attachements. Is it possible to change this macro to e-mail out as the body of the e-mail text rather than an attachement? |
e-mail macro
Hi cjmike
See my site for example code and example workbooks http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... I currently have a macro set up that will e-mail out different worksheets as e-mail attachements. Is it possible to change this macro to e-mail out as the body of the e-mail text rather than an attachement? |
e-mail macro
Many thanks.
One quick question, Can you explain this in a little more detail? "Don't forget to copy the function RangetoHTML in the module." Many thanks. "Ron de Bruin" wrote: Hi cjmike See my site for example code and example workbooks http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... I currently have a macro set up that will e-mail out different worksheets as e-mail attachements. Is it possible to change this macro to e-mail out as the body of the e-mail text rather than an attachement? |
e-mail macro
The macro call the function to create the html in this line
.HTMLBody = RangetoHTML(rng) If it can't find the function it is not working Copy both in a module and run the macro http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... Many thanks. One quick question, Can you explain this in a little more detail? "Don't forget to copy the function RangetoHTML in the module." Many thanks. "Ron de Bruin" wrote: Hi cjmike See my site for example code and example workbooks http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... I currently have a macro set up that will e-mail out different worksheets as e-mail attachements. Is it possible to change this macro to e-mail out as the body of the e-mail text rather than an attachement? |
e-mail macro
Many thanks.
One other question, if I add pictures or shapes to the worksheet these do not come through with the e-mail. Is there a way round this? "Ron de Bruin" wrote: The macro call the function to create the html in this line .HTMLBody = RangetoHTML(rng) If it can't find the function it is not working Copy both in a module and run the macro http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... Many thanks. One quick question, Can you explain this in a little more detail? "Don't forget to copy the function RangetoHTML in the module." Many thanks. "Ron de Bruin" wrote: Hi cjmike See my site for example code and example workbooks http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... I currently have a macro set up that will e-mail out different worksheets as e-mail attachements. Is it possible to change this macro to e-mail out as the body of the e-mail text rather than an attachement? |
e-mail macro
Hi cjmike
Read the more Information part below the macro on my page http://www.rondebruin.nl:80/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... Many thanks. One other question, if I add pictures or shapes to the worksheet these do not come through with the e-mail. Is there a way round this? "Ron de Bruin" wrote: The macro call the function to create the html in this line .HTMLBody = RangetoHTML(rng) If it can't find the function it is not working Copy both in a module and run the macro http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... Many thanks. One quick question, Can you explain this in a little more detail? "Don't forget to copy the function RangetoHTML in the module." Many thanks. "Ron de Bruin" wrote: Hi cjmike See my site for example code and example workbooks http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... I currently have a macro set up that will e-mail out different worksheets as e-mail attachements. Is it possible to change this macro to e-mail out as the body of the e-mail text rather than an attachement? |
e-mail macro
Many thanks.
"Ron de Bruin" wrote: Hi cjmike Read the more Information part below the macro on my page http://www.rondebruin.nl:80/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... Many thanks. One other question, if I add pictures or shapes to the worksheet these do not come through with the e-mail. Is there a way round this? "Ron de Bruin" wrote: The macro call the function to create the html in this line .HTMLBody = RangetoHTML(rng) If it can't find the function it is not working Copy both in a module and run the macro http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... Many thanks. One quick question, Can you explain this in a little more detail? "Don't forget to copy the function RangetoHTML in the module." Many thanks. "Ron de Bruin" wrote: Hi cjmike See my site for example code and example workbooks http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cjmike" wrote in message ... I currently have a macro set up that will e-mail out different worksheets as e-mail attachements. Is it possible to change this macro to e-mail out as the body of the e-mail text rather than an attachement? |
| All times are GMT +1. The time now is 05:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com