Send worksheet by E-Mail
 

I have a workbook with several worksheets. Sheet1 ("menu") has a command
button which when pressed it attaches sheet8 ("send") as a attachement as a
excel sheet with macros and formulas. I would like to amend this so that the
worksheet ("send") is sent as the main body of a E-Mail and also cancel all
the formalas and macros on this sheet. This may be as clear as mud but if
there are any questions please please get in touch!!!!!
Thank you
--
AOU

Send worksheet by E-Mail
 

Nel post
*AOU* ha scritto:

I have a workbook with several worksheets. Sheet1 ("menu") has a
command button which when pressed it attaches sheet8 ("send") as a
attachement as a excel sheet with macros and formulas. I would like
to amend this so that the worksheet ("send") is sent as the main body
of a E-Mail and also cancel all the formalas and macros on this
sheet. This may be as clear as mud but if there are any questions
please please get in touch!!!!!
Thank you

Hi AOU,

To send e-mail from Excel, the best place to see is Ron de Bruin site:

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



--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Send worksheet by E-Mail
 

Thanks very much
--
AOU


"Franz Verga" wrote:

Nel post
*AOU* ha scritto:

I have a workbook with several worksheets. Sheet1 ("menu") has a
command button which when pressed it attaches sheet8 ("send") as a
attachement as a excel sheet with macros and formulas. I would like
to amend this so that the worksheet ("send") is sent as the main body
of a E-Mail and also cancel all the formalas and macros on this
sheet. This may be as clear as mud but if there are any questions
please please get in touch!!!!!
Thank you

Hi AOU,

To send e-mail from Excel, the best place to see is Ron de Bruin site:

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



--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy