return excel file by email

  • Thread starter Thread starter Steve Goodrich
  • Start date Start date
S

Steve Goodrich

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
 
Back
Top