I have several worksheets in an excel spreadsheet and I want to send 1 of
them to an email recipient, Is this possible without copying the worksheet to
a new spreadsheet?

No, a worksheet cannot exist on its own. It must be part of a
workbook. Copy the desired worksheet to a new workbook and email
that workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chantymer" wrote in message
...
I have several worksheets in an excel spreadsheet and I want to
send 1 of
them to an email recipient, Is this possible without copying
the worksheet to
a new spreadsheet?

Hi Chantymer

Install my E-mail add -in for this
http://www.rondebruin.nl/mail/add-in.htm

Or use a code example
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Chantymer" wrote in message ...
I have several worksheets in an excel spreadsheet and I want to send 1 of
them to an email recipient, Is this possible without copying the worksheet to
a new spreadsheet?

If you save in a new worksheet. When you send it to recipient dont they get a
message saying it is a part of another workbook do you wish to open other
workbook. Or is that because I have macros in mine.

"Chip Pearson" wrote:

No, a worksheet cannot exist on its own. It must be part of a
workbook. Copy the desired worksheet to a new workbook and email
that workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chantymer" wrote in message
...
I have several worksheets in an excel spreadsheet and I want to
send 1 of
them to an email recipient, Is this possible without copying
the worksheet to
a new spreadsheet?

Maybe it's a link message that the recipient is getting. If the original
workbook had two worksheets (Sheet1 and Sheet2) and you wanted to send Sheet2.

But Sheet2 has a formula in it that looked like this:
=sheet1!a1

That formula changes to:
=[Book1.xls]Sheet1!A1
And if I close Book1.xls, the formula changes again to:
='C:\My Documents\excel\[Book1.xls]Sheet1'!A1

If I send Sheet2 with a formula like that, excel can ask (if the user chooses to
be prompted) if it should try to find that workbook and retrieve the current
value.

Depending on what you're doing, you could just change that formula to a value.
(select that cell, edit|copy, edit|paste special|Values).




raven wrote:

If you save in a new worksheet. When you send it to recipient dont they get a
message saying it is a part of another workbook do you wish to open other
workbook. Or is that because I have macros in mine.

"Chip Pearson" wrote:

No, a worksheet cannot exist on its own. It must be part of a
workbook. Copy the desired worksheet to a new workbook and email
that workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chantymer" wrote in message
...
I have several worksheets in an excel spreadsheet and I want to
send 1 of
them to an email recipient, Is this possible without copying
the worksheet to
a new spreadsheet?




--

Dave Peterson

I cam to the discussion group to see if anyone knew this answer, and was
thrilled to find your link. thanks so much for posting it...saved me a BUNCH
of work...
Suzanne

"Ron de Bruin" wrote:

Hi Chantymer

Install my E-mail add -in for this
http://www.rondebruin.nl/mail/add-in.htm

Or use a code example
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Chantymer" wrote in message ...
I have several worksheets in an excel spreadsheet and I want to send 1 of
them to an email recipient, Is this possible without copying the worksheet to
a new spreadsheet?