My final question

Hi Again,

This is my last question I promise,

I have finished my project almost but I was wanting to know I'm setting up a macro which I hope will just send that one sheet in an email not as an attachment.

is there any code that someone knows or how I can do this.

thanks again for you all help

You can get lots of examples and tips from Ron de Bruin's site:

http://www.rondebruin.nl/

Pete

How about what Daniel Klann has done here ..

http://www.danielklann.com/excel/sen...s_the_body.htm

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"Reign" <Reign.1zaggm_1133318400.6186@excelforum-nospam.com> wrote in
message news:Reign.1zaggm_1133318400.6186@excelforum-nospam.com...
>
> Hi Again,
>
> This is my last question I promise,
>
> I have finished my project almost but I was wanting to know I'm setting
> up a macro which I hope will just send that one sheet in an email not as
> an attachment.
>
> is there any code that someone knows or how I can do this.
>
> thanks again for you all help
>
>
> --
> Reign
> ------------------------------------------------------------------------
> Reign's Profile:
> http://www.excelforum.com/member.php...o&userid=29134
> View this thread: http://www.excelforum.com/showthread...hreadid=489301
>