Macro for Emailing a spreadsheet
 

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
--
Regards
Michael Mitchelson

Macro for Emailing a spreadsheet
 

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??? :o)

Best regards

Markus

Macro for Emailing a spreadsheet
 

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

--

HTH

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


"Michael" wrote in message
...
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
--
Regards
Michael Mitchelson

Macro for Emailing a spreadsheet
 

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

Regards
Michael

"Michael" wrote:

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
--
Regards
Michael Mitchelson