See Ron de Bruin's site for code.
Also not his SendMail Add-in which has all the work done for you.
http://www.rondebruin.nl/sendmail.htm
Gord Dibben MS Excel MVP
On Mon, 24 Mar 2008 15:27:02 -0700, Neil wrote:
how do you set up a link that can be clicked on that sends the data on the
spreadsheet that the link is in via email as an attachment or a page etc