Macro for Emailing a spreadsheet

[Guest]

Hi All
I have created an Excel workbook for my boss with forms and dropdowns etc.
He has decided that he wants a Button on the screen that will allow him to
E-Mail the completed form back to me when he has filled it in.
Is it possible to do this with a Macro from within Excel
Any advice, code, suggestions, etc, would be greatly appreciated.
Getting a new boss is not an option

 

[Markus Scheible]

Hi Michael,

He has decided that he wants a Button on the screen that will allow him to
E-Mail the completed form back to me when he has filled it in.
Is it possible to do this with a Macro from within Excel
Any advice, code, suggestions, etc, would be greatly

appreciated.

Try

Sheets("whatever").Range("whatever").Activate
Application.Dialogs(xlDialogSendMail).Show

Or Select and Activate the Form... it depends if he would
just send you the data or the complete layout withing the
worksheet...

Then you can connect that Macro with a button and voila!

Getting a new boss is not an option
--

WHY NOT??? )

Best regards

Markus

 

[Bob Phillips]

Take a look at www.rondebruin.nl/sendmail.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks guys
That is just what I needed. Thank you for a quick and efficient response.

Regards
Michael