John, have a look at some of Ron de Bruin's code here to do it

http://www.rondebruin.nl/sendmail.htm#Workbook.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JonnieP" wrote in message
...
Hi

I have added a button to my spreadsheet that allows users to add the sheet
to an email ready to send, but i really want it to populate the email
address
so it sends it straight to me rather than having to rely on users to input
my
address (they are a bit slow I'm afraid!!!)

Thanks

John