return excel file by email

[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

 

[Ron de Bruin]

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

 

[Steve Goodrich]

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

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