software

Is there a way to email one spreadsheet of a workbook file as an
attachment in Excel 2003?

I don't want to email the whole workbook file and I don't want to email
the spreadsheet in the body of the email, and these seem to be the only
other options available.

I would like to be able to do this without using an addin or other
method outside the standard ones available in Excel.

Thanks!
Select the Sheet you want to save - then select quot;Save Asquot; then select
Comma Seperated Values (CSV) or Tabbed and follow the directions.
Then the end user should be able to open and import the file into
Excel.
Make a copy of your workbook prior to doing the above incase the
results are not what you want.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=496265Bob

Copy the one sheet to a new workbook and save.

Email that workbook as an attachment.Gord Dibben Excel MVP

On 27 Dec 2005 12:41:49 -0800, wrote:

gt;Is there a way to email one spreadsheet of a workbook file as an
gt;attachment in Excel 2003?
gt;
gt;I don't want to email the whole workbook file and I don't want to email
gt;the spreadsheet in the body of the email, and these seem to be the only
gt;other options available.
gt;
gt;I would like to be able to do this without using an addin or other
gt;method outside the standard ones available in Excel.
gt;
gt;Thanks!

I'm hoping there is a method that doesn't require me to first save the
worksheet as a separate file. I would like to be able to send it as an
email attachement from within the open workbook.

The workbook file has already been saved and I just want to email as an
attachement one of the spreadsheets in the workbook.
Save your workbook first - then do a quot;SAVE ASquot;
Then when you close the workbook - and the ? is do you want to save
changes quot;select NO.quot;--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=496265Not without using an Add-in which you stated you did not want.Gord

On 27 Dec 2005 13:40:42 -0800, wrote:

gt;I'm hoping there is a method that doesn't require me to first save the
gt;worksheet as a separate file. I would like to be able to send it as an
gt;email attachement from within the open workbook.
gt;
gt;The workbook file has already been saved and I just want to email as an
gt;attachement one of the spreadsheets in the workbook.

Ok, I changed my mind and would like to use an add-in since there isn't
an alternative other than saving and creating a new file.

Do you have an add-in link?

Thanks!Ron de Bruin has an addin that you may like:
www.rondebruin.nl/mail/add-in.htm

If you want more control (by writing your own), Ron has tons of sample code:
www.rondebruin.nl/sendmail.htm
wrote:
gt;
gt; Ok, I changed my mind and would like to use an add-in since there isn't
gt; an alternative other than saving and creating a new file.
gt;
gt; Do you have an add-in link?
gt;
gt; Thanks!

--

Dave Peterson