Macro to email workbook back to sender

E

ExcelNoviceGuy

I have a survey in an Excel file which is emailed to a user to complete
At the end of the survey, the user presses a button which activates
macro to pull up the mail dialog. I'd like to alter the VB code i
this macro to further automate this process including automaticall
writing the original sender's address in the To: line of the mai
dialog and re-naming the workbook using text strings (e.g. name, dept.
the user enters at the start of the survey. Ideas
 
H

Harald Staff

Hi

Ron has tons of code at
http://www.rondebruin.nl/sendmail.htm
but these things will depend a lot on the user's email cliens and OS. If
your user is on a Mac using whatevertheyemailfromMacswith then it may be
difficult to control fully.

HTH. Best wishes Harald
 
Top