| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SendMail only one sheet, not entire workbook
is it possible that I can write a macro that will enable me to send only the
active sheet as the body of an email message rather than sending the entire workbook as an attachment? I know I can do so manually. But I was hoping to do it as part of a macro. -- Respectfully Matthew Russell |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SendMail only one sheet, not entire workbook
Hi
use Ron's Sendmail addin: http://www.rondebruin.nl/mail/add-in.htm -- Regards Frank Kabel Frankfurt, Germany "Matthew" schrieb im Newsbeitrag ... is it possible that I can write a macro that will enable me to send only the active sheet as the body of an email message rather than sending the entire workbook as an attachment? I know I can do so manually. But I was hoping to do it as part of a macro. -- Respectfully Matthew Russell |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SendMail only one sheet, not entire workbook
Hi Matthew
See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... is it possible that I can write a macro that will enable me to send only the active sheet as the body of an email message rather than sending the entire workbook as an attachment? I know I can do so manually. But I was hoping to do it as part of a macro. -- Respectfully Matthew Russell |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SendMail only one sheet, not entire workbook
Thank you for your reply. My concern is this; if I use the sendmail addin
that you suggest, can it be processed without user intervention and invoked from a macro script? I want the user to click a form button that runs a macro afterwhich it sends a particular sheet as an email message. "Ron de Bruin" wrote: Hi Matthew See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... is it possible that I can write a macro that will enable me to send only the active sheet as the body of an email message rather than sending the entire workbook as an attachment? I know I can do so manually. But I was hoping to do it as part of a macro. -- Respectfully Matthew Russell |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SendMail only one sheet, not entire workbook
Hi Matthew
I have also a code example on my site for this. http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... Thank you for your reply. My concern is this; if I use the sendmail addin that you suggest, can it be processed without user intervention and invoked from a macro script? I want the user to click a form button that runs a macro afterwhich it sends a particular sheet as an email message. "Ron de Bruin" wrote: Hi Matthew See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... is it possible that I can write a macro that will enable me to send only the active sheet as the body of an email message rather than sending the entire workbook as an attachment? I know I can do so manually. But I was hoping to do it as part of a macro. -- Respectfully Matthew Russell |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SendMail only one sheet, not entire workbook
Thank you Ron. I tried your suggestion and it works in the sense that it
sends only the sheet. And I apologize if I seem "picky" but when it was processing the message I got a 'warning' that email was being sent and I had to click another button to allow it. I would like to avoid any intervention like that and just have the email sent automatically. Furthermore, when I reviewed the email message I found that some of the graphic elements from the Excel worksheet were lost when it became the body of the email message. Any advice? Thanks in advance. Matthew "Ron de Bruin" wrote: Hi Matthew I have also a code example on my site for this. http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... Thank you for your reply. My concern is this; if I use the sendmail addin that you suggest, can it be processed without user intervention and invoked from a macro script? I want the user to click a form button that runs a macro afterwhich it sends a particular sheet as an email message. "Ron de Bruin" wrote: Hi Matthew See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... is it possible that I can write a macro that will enable me to send only the active sheet as the body of an email message rather than sending the entire workbook as an attachment? I know I can do so manually. But I was hoping to do it as part of a macro. -- Respectfully Matthew Russell |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SendMail only one sheet, not entire workbook
Hi
See http://www.rondebruin.nl/mail/prevent.htm reviewed the email message I found that some of the graphic elements from the Excel worksheet were lost when it became the body of the email message. Correct From my site : If you use Office 2002 or 2003 see this KB article. How to Send a Range of Cells Using VBA. (with shapes) http://support.microsoft.com/default...b;en-us;816644 -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... Thank you Ron. I tried your suggestion and it works in the sense that it sends only the sheet. And I apologize if I seem "picky" but when it was processing the message I got a 'warning' that email was being sent and I had to click another button to allow it. I would like to avoid any intervention like that and just have the email sent automatically. Furthermore, when I reviewed the email message I found that some of the graphic elements from the Excel worksheet were lost when it became the body of the email message. Any advice? Thanks in advance. Matthew "Ron de Bruin" wrote: Hi Matthew I have also a code example on my site for this. http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... Thank you for your reply. My concern is this; if I use the sendmail addin that you suggest, can it be processed without user intervention and invoked from a macro script? I want the user to click a form button that runs a macro afterwhich it sends a particular sheet as an email message. "Ron de Bruin" wrote: Hi Matthew See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... is it possible that I can write a macro that will enable me to send only the active sheet as the body of an email message rather than sending the entire workbook as an attachment? I know I can do so manually. But I was hoping to do it as part of a macro. -- Respectfully Matthew Russell |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SendMail only one sheet, not entire workbook
Ron, Thank you very much for your reply. I feel stupid having forgotten
about the 'sendkeys' function. I apologize for that. It's a quick and simple solution. With regards to your 2nd part... I'm working with Outlook 2000. Does that mean that I would have to accept the possibility of missing graphic images since the resolution you refer to works with Outlook 2002? Thanks again... "Ron de Bruin" wrote: Hi See http://www.rondebruin.nl/mail/prevent.htm reviewed the email message I found that some of the graphic elements from the Excel worksheet were lost when it became the body of the email message. Correct From my site : If you use Office 2002 or 2003 see this KB article. How to Send a Range of Cells Using VBA. (with shapes) http://support.microsoft.com/default...b;en-us;816644 -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... Thank you Ron. I tried your suggestion and it works in the sense that it sends only the sheet. And I apologize if I seem "picky" but when it was processing the message I got a 'warning' that email was being sent and I had to click another button to allow it. I would like to avoid any intervention like that and just have the email sent automatically. Furthermore, when I reviewed the email message I found that some of the graphic elements from the Excel worksheet were lost when it became the body of the email message. Any advice? Thanks in advance. Matthew "Ron de Bruin" wrote: Hi Matthew I have also a code example on my site for this. http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... Thank you for your reply. My concern is this; if I use the sendmail addin that you suggest, can it be processed without user intervention and invoked from a macro script? I want the user to click a form button that runs a macro afterwhich it sends a particular sheet as an email message. "Ron de Bruin" wrote: Hi Matthew See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... is it possible that I can write a macro that will enable me to send only the active sheet as the body of an email message rather than sending the entire workbook as an attachment? I know I can do so manually. But I was hoping to do it as part of a macro. -- Respectfully Matthew Russell |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SendMail only one sheet, not entire workbook
With regards to your 2nd part... I'm working with Outlook 2000. Does that
mean that I would have to accept the possibility of missing graphic images since the resolution you refer to works with Outlook 2002? Yes -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... Ron, Thank you very much for your reply. I feel stupid having forgotten about the 'sendkeys' function. I apologize for that. It's a quick and simple solution. With regards to your 2nd part... I'm working with Outlook 2000. Does that mean that I would have to accept the possibility of missing graphic images since the resolution you refer to works with Outlook 2002? Thanks again... "Ron de Bruin" wrote: Hi See http://www.rondebruin.nl/mail/prevent.htm reviewed the email message I found that some of the graphic elements from the Excel worksheet were lost when it became the body of the email message. Correct From my site : If you use Office 2002 or 2003 see this KB article. How to Send a Range of Cells Using VBA. (with shapes) http://support.microsoft.com/default...b;en-us;816644 -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... Thank you Ron. I tried your suggestion and it works in the sense that it sends only the sheet. And I apologize if I seem "picky" but when it was processing the message I got a 'warning' that email was being sent and I had to click another button to allow it. I would like to avoid any intervention like that and just have the email sent automatically. Furthermore, when I reviewed the email message I found that some of the graphic elements from the Excel worksheet were lost when it became the body of the email message. Any advice? Thanks in advance. Matthew "Ron de Bruin" wrote: Hi Matthew I have also a code example on my site for this. http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... Thank you for your reply. My concern is this; if I use the sendmail addin that you suggest, can it be processed without user intervention and invoked from a macro script? I want the user to click a form button that runs a macro afterwhich it sends a particular sheet as an email message. "Ron de Bruin" wrote: Hi Matthew See http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Matthew" wrote in message ... is it possible that I can write a macro that will enable me to send only the active sheet as the body of an email message rather than sending the entire workbook as an attachment? I know I can do so manually. But I was hoping to do it as part of a macro. -- Respectfully Matthew Russell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you PDF an entire Excel workbook versus one sheet at a time | Excel Discussion (Misc queries) | |||
| How to print entire workbook 9 pages to a sheet? | Excel Worksheet Functions | |||
| Send entire workbook/current sheet pop-up box. | Excel Discussion (Misc queries) | |||
| Send entire workbook/current sheet pop-up box. | Excel Discussion (Misc queries) | |||
| How can I set up headers/footers for an entire workbook vs sheet | Excel Discussion (Misc queries) | |||
Linear Mode
