ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Attaching sheet to e-mail (https://www.excelbanter.com/excel-programming/342560-attaching-sheet-e-mail.html)

Brian Matlack[_5_]

Attaching sheet to e-mail
 

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

--
Brian Matlac
-----------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350
View this thread: http://www.excelforum.com/showthread.php?threadid=47541


Ron de Bruin

Attaching sheet to e-mail
 
Look here Brian
http://www.rondebruin.nl/sendmail.htm


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


"Brian Matlack" wrote in message
news:Brian.Matlack.1wsoae_1129129528.8297@excelfor um-nospam.com...

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




Brian Matlack[_6_]

Attaching sheet to e-mail
 

Thanks Ron Lots of Good Info


--
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



All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com