G
Guest
I am sending a workbook with blank forms to 50 different people, asking them
to complete them and return them to me as attachments in an email. I am
hoping that I can assign a macro to a button which will make the process
easier for them:
1) clicking the button starts the File>Send to>As Attachment routine
2) fills in my email address in the "To" line of the MS Outlook email screen
3) sends the email with the attachment to me
Is there a way to automate this process, so that the users do not have to
figure out how to do it and/or to look for my email address. I tried to
record the macro in Excel but, as soon as the Outlook email screen appears, I
lose control of the macro. Is there any way to accomplish this?
Many thanks!
to complete them and return them to me as attachments in an email. I am
hoping that I can assign a macro to a button which will make the process
easier for them:
1) clicking the button starts the File>Send to>As Attachment routine
2) fills in my email address in the "To" line of the MS Outlook email screen
3) sends the email with the attachment to me
Is there a way to automate this process, so that the users do not have to
figure out how to do it and/or to look for my email address. I tried to
record the macro in Excel but, as soon as the Outlook email screen appears, I
lose control of the macro. Is there any way to accomplish this?
Many thanks!