How do I enable emailing a worksheet in Excel?

R

Roger Fulton

I can email the entire workbook but not just a worksheet. We use Exchange
Server and Office 2003.
 
R

Richard Buttrey

On Mon, 4 Sep 2006 09:48:01 -0700, Roger Fulton <Roger
I can email the entire workbook but not just a worksheet. We use Exchange
Server and Office 2003.
Click to expand...

Have you tried copying the worksheet to a new single sheet workbook of
it's own and then emailing that?

AFAIAA there is no Excel equivalent of the Lotus 123 File Extract
command, which did allow just a single sheet to be saved as a separate
file, in one step.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
R

Roger Fulton

Thanks for the suggestion although I was hoping to avoid doing that. I can
email the single worksheet from some terminals but not the one I usually work
at and it can be a drag just to log on to a different terminal for the sole
purpose of emailing a worksheet. I could wait for our Help Desk to fix it but
was hoping to get this taken care of before the end of September.
 
R

Richard

Maybe I'm missing something, but are you saying you can email a single
sheet workbook but only from some PCs? What about a multi-sheet
workbook?

If that's the case then surely it suggests a hardware problem, not an
Excel problem?

Can you post the macro code that you're running, which presumably
creates, or at least identifies the workbook to be emailed, and which
then carries on and attaches the workbook to an Outlook email message.

Rgds
 
R

Roger Fulton

I am not running any particular macros. We are trying to send a single
worksheet from a multi-sheet workbook. We do not want to send the entire
workbook.

In our office we provide a daily report to management on the network
connectivity of some of the remote work sites we monitor. All information is
hand entered and then the worksheet is emailed using the link to Outlook
provided in the icon bar at the top of the screen. A pop-up window asks if I
want to send the entire workbook or the worksheet and when I choose to send
just the worksheet (which is all management wants to receive), another pop-up
announces that Excel could not start the e-mail program. This only happens
on some of the terminals.

The problem I am having is that it doesn't happen on all the terminals in
our work area and it doesn't happen to all employees. Also, some employees
can send the worksheet from one terminal while others cannot but on another
terminal the problem affects these same employees the opposite way. All
employees can send the report from at least one of the terminals but we don't
always sit at the same terminal.

Is there a way to set all terminals so that all employees are able to send
just the worksheet no matter which terminal they are working from on any
given day? The Excel file we are using is shared (we also use it for our
daily log).

Roger
 
S

shail

Hi Roger,

I am using Windows XP and Office XP. When I choose email from Excel, it
let me choose the option whether to email the whole workbook or just a
single worksheet as an attachment. I am wondering why it is not with
you.

Thanks,

Shail
 
R

Roger Fulton

That's what I have been asking. When I choose to send the single worksheet, I
get an error message that Excel is unable to open the e-mail program but if I
choose to send the whole workbook as an attachment there is no problem. To
make things worse, it only happens on some of the terminals that I work from.
 
Top