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 "Save As" 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: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=496265

Bob

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:

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!

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 "SAVE AS"
Then when you close the workbook - and the ? is do you want to save
changes "select NO."


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=496265

Not without using an Add-in which you stated you did not want.


Gord

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

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.

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:
http://www.rondebruin.nl/mail/add-in.htm

If you want more control (by writing your own), Ron has tons of sample code:
http://www.rondebruin.nl/sendmail.htm

wrote:

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!

--

Dave Peterson