Hyperlink to email active workbook via groupwise

[CARAS SDT1]

I am currently trying to set up a hyperlink so that once someone has finished an excel survey they can just press the e-mail hyperlink in a cell and it will automatically send the active workbook attached in their e-mail to gccarasservicedevelop@health.qld.com.au.
I have managed to add a hyperlink to open an e-mail ok however the workbook does not attach to it? Any ideas to help?
Thanks
Terry

 

[MalcolmS]

Terry, have a look at http://www.rondebrun.nl/sendmail.htm for some top tips on the subject.

At it's simplest, add a command button to your worksheet and add this line to its click event

activeworkbook.sendmail "email address in quotes<EMAIL quotes in address>", "subject line in quotes<SUBJECT quotes in line>"

This will normally generate a warning from the mail client.