how can i use sendmail where i want the user to type the email address they wish to send the workbook to?
if i do it via a form, what will the code be for the send button as the sendmail code i have at the moment is the one where you have to type in the email addresses in the actual code itself. this does not allow the user to send it to who ever they want to send it to.
all help needed and appreciated
thanks
if i do it via a form, what will the code be for the send button as the sendmail code i have at the moment is the one where you have to type in the email addresses in the actual code itself. this does not allow the user to send it to who ever they want to send it to.
all help needed and appreciated

thanks