Attaching sheet to e-mail

**Brian Matlack** · 10-12-2005, 10:09 AM

Hi!
I am working with excel 2003
I would like to attach a worksheet (not the entire workbook) to an e-mail. I would like to do it as an excel worksheet if possible but I can make it work as a body of text as well. What would the code look like for this.
The user is accessing my workbook file (read only) through a website and when they fill-out the form they click a button and the macro e-mails the form worksheet to my e-mail address. This is an attempt at doing "On-Line" warranty claims.
Any help or suggestions would be greatly appriciated.

Ron de Bruin · 10-12-2005, 01:05 PM

Look here Brian
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Brian Matlack" <[email protected]> wrote in message
news:[email protected]...
>
> Hi!
> I am working with excel 2003
> I would like to attach a worksheet (not the entire workbook) to an
> e-mail. I would like to do it as an excel worksheet if possible but I
> can make it work as a body of text as well. What would the code look
> like for this.
> The user is accessing my workbook file (read only) through a website
> and when they fill-out the form they click a button and the macro
> e-mails the form worksheet to my e-mail address. This is an attempt at
> doing "On-Line" warranty claims.
> Any help or suggestions would be greatly appriciated.
>
>
> --
> Brian Matlack
> ------------------------------------------------------------------------
> Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
> View this thread: http://www.excelforum.com/showthread...hreadid=475419
>