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 FileSend toAs 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!

Hi KG

Start here
http://www.rondebruin.nl/sendmail.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"KG" wrote in message ...
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 FileSend toAs 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!

Thank you!

"Ron de Bruin" wrote:

Hi KG

Start here
http://www.rondebruin.nl/sendmail.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"KG" wrote in message ...
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 FileSend toAs 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!