Sending Excel sheet without macros

K

Kevin Stecyk

Melinda,

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

Hope that helps.

Best regards,
Kevin
 
M

Melinda

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
M

Melinda

-----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
[email protected]
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
 
K

Kevin Stecyk

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
 
Top