I have compiled a staff survey in Excel 2003 which I intend to e-mail to 700
staff.
The survey will be completed on the spreadsheet by clicking check boxes then
returned to me via e-mail.

Can I add a button to the spreadsheet which can be clicked by the user which
will return the spreadsheet to me
This is instead of the user detaching the file from the e-mail, completing
the survey and attaching it to a new e-mail.

I have seen other examples of this but I don't know where to start.
Can it be done with a macro or does it require code

Thanks
Steve Goodrich

Hi Steve

You can find code on this page (Use SendMail)
Be aware that opening the file inside the mail can give problems and that users can
have security set to High so no code will Run. Also some mail programs will not work with the code.

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





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve Goodrich" wrote in message ...
I have compiled a staff survey in Excel 2003 which I intend to e-mail to 700
staff.
The survey will be completed on the spreadsheet by clicking check boxes then
returned to me via e-mail.

Can I add a button to the spreadsheet which can be clicked by the user which
will return the spreadsheet to me
This is instead of the user detaching the file from the e-mail, completing
the survey and attaching it to a new e-mail.

I have seen other examples of this but I don't know where to start.
Can it be done with a macro or does it require code

Thanks
Steve Goodrich

Thanks for the advice, I'll take a look.

"Ron de Bruin" wrote in message
...
Hi Steve

You can find code on this page (Use SendMail)
Be aware that opening the file inside the mail can give problems and that
users can have security set to High so no code will Run. Also some mail
programs will not work with the code.

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





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve Goodrich" wrote in message
...
I have compiled a staff survey in Excel 2003 which I intend to e-mail to
700
staff.
The survey will be completed on the spreadsheet by clicking check boxes
then
returned to me via e-mail.

Can I add a button to the spreadsheet which can be clicked by the user
which
will return the spreadsheet to me
This is instead of the user detaching the file from the e-mail,
completing
the survey and attaching it to a new e-mail.

I have seen other examples of this but I don't know where to start.
Can it be done with a macro or does it require code

Thanks
Steve Goodrich