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