Does anybody know if it is possible to send a link to the curren
spreadsheet when using the SendMail function in Excel rather than i
sending a copy of the spreadsheet? Or alternatively, is it possibl
not to send a spreadsheet at all when using SendMail (and just sen
text instead?) Thank

--
Message posted from http://www.ExcelForum.com

Hi Jenny,
for the or alternatively:

See John Walkenbach's "Elephants 'R Us"
Mail Merge - Without Word
http://www.j-walk.com/ss/excel/tips/tip92.htm
or Ron de Bruin's website
Example Code for sending mail from Excel
http://www.rondebruin.nl/sendmail.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jennyfarrell " wrote in message ...
Does anybody know if it is possible to send a link to the current
spreadsheet when using the SendMail function in Excel rather than it
sending a copy of the spreadsheet? Or alternatively, is it possible
not to send a spreadsheet at all when using SendMail (and just send
text instead?) Thanks


---
Message posted from http://www.ExcelForum.com/

Perhaps I should have asked you what you actually have
and the link is that you want to send, will those who receive
the link see the file name same as you.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jennyfarrell " ...
Does anybody know if it is possible to send a link to the current