View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Steve Goodrich Steve Goodrich is offline
external usenet poster
 
Posts: 3
Default return excel file by email

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