Sending Excel sheet without macros

  • Thread starter Thread starter Melinda Burns
  • Start date Start date
Melinda,

Just save the workbook, compose your e-mail, and then add the worksheet as
an attachment.

Hope that helps.

Best regards,
Kevin
 
So you are saying that by sending the worksheet as an
attachment rather than sending from Excel, will send the
worksheet without the macros?

Melinda
 
Hi Melinda!

Pay a visit to:

Ron de Bruin
http://www.rondebruin.nl/sendmail-addin.htm

Download the SendMail 3.0 Addin plus User Guide. You'll find that the
simple to use Addin puts a SendMail item on your Tools Menu and that
one of the many options is to send the entire workbook without any VBA
code. The user guide should answer any queries you have about
installation, use and options available.

The link I've given is if you are using Outlook. If using Outlook
Express use:

http://www.rondebruin.nl/sendmail.htm#Add-in

That gives you access to SendMail 2.1 which still allows sending
without the VBA code.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Melinda!

No it won't! It sends it complete with your VBA code.

Kevin was misunderstanding your question. He thought that you wanted
to perform the operation without code.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
-----Original Message-----
Hi Melinda!

Pay a visit to:

Ron de Bruin
http://www.rondebruin.nl/sendmail-addin.htm

Download the SendMail 3.0 Addin plus User Guide. You'll find that the
simple to use Addin puts a SendMail item on your Tools Menu and that
one of the many options is to send the entire workbook without any VBA
code. The user guide should answer any queries you have about
installation, use and options available.

The link I've given is if you are using Outlook. If using Outlook
Express use:

http://www.rondebruin.nl/sendmail.htm#Add-in

That gives you access to SendMail 2.1 which still allows sending
without the VBA code.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.


.
Norman,

Thanks for the info. I will download this software and
test it.

Melinda
 
Hi Norman,

<<Kevin was misunderstanding your question. He thought that you wanted
to perform the operation without code.>>

Thank you for jumping in!

Best regards,
Kevin
 
Back
Top