| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a excel macro that runs a mail merge print the letters? | Excel Discussion (Misc queries) | |||
| Macro question | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Mail Merge macro | Excel Discussion (Misc queries) | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
Linear Mode
