Open Outlook and send email

[linsonline]

Does anyone have a macro which will enable me to open Outlook from an Excel form.

I have a multi sheet Excel form which is sent out to various people and, once they have completed it, I need a macro button which will open Outlook, attached the completed form and send it back to me.

Is this possible?

Thanks

[ChemistB]

Yes, Ron gives a lot of examples here depending on your system.

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

However, odds are that (because of security settings) Outlook will ask the user if they want to send the email before it sends it so it won't be completely automatic.

[jaslake]

Hi linsonline
Post a sample of your file...should you need it, I'll help you adapt "Ron's" code to your requirements.