If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
return excel file by email
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 |
#2
|
|||
|
|||
return excel file by email
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|