Send link to Excel spreadsheet

[jennyfarrell]

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

 

[David McRitchie]

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

 

[David McRitchie]

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.