Excel 2007 - Send a selection as a mail Message Body

[Seanie]

Has the feature "Send a selection as an e-mail message body" been
removed from Excel 2007? I can see how to send the whole worksheet as
an e-mail message body but not a selection

 

[Ron de Bruin]

Hi Seanie

http://www.rondebruin.nl/notinribbon.htm

The name is
Send to Mail Recipient

Choose send the sheet in the body
in the second dialog the button say "Send this selction"

The option to send a chart is removed in Excel 2007

 

[Seanie]

Thanks Ron, I tried that but it only gives you 2 options when selected

1) Send the entire workbook as an attachment
2) Send the current worksheet as the message body

On 2003 you could select a range and just e-mail that area only as the
message body

I'm assuming it can't now be done on 2007. Do you have any code on
your Web site that sends a selected range. eg. if I range an area,
then action code that sends that selected range as the message body?
My issue is that I have one file who's range that I have to e-mail out
changes each week, so I don't want to hard code in an area that I have
to change each week

 

[Ron de Bruin]

2) Send the current worksheet as the message body

Choose this one

If you have more then one cell selected the button say this
in the second dialog the button say "Send this selection" now

 

[Seanie]

Thanks Ron, yes it worked like that, I thought when I saw the whole
sheet included within the message body, that it would send the lot

 

[Ron de Bruin]

I agree that it is confusing

 

[Ron de Bruin]

Hi Seanie

FYI
I create a bug report about it.
I hope they will change the caption of the button in the first dialog in the next Excel version

 

[Seanie]

Good move Ron, you expect each each new version to improve on the
last, but this particular aspect seems to be a backward step, in
particular when its not intuitive that it does as before

 

[Ron de Bruin]

I think it is also stupid that it is not in this menu

OfficeButton>Send

 

[verma_sahil]

Hi Ron,
I am trying to send the range of rows in the body of mail by referring your code but it is sending without any borders of cells.
The mail format is like:

sdbdbs dsjds
bddsbdb bsbfbs
bjssb sbb

Can you please help so that i will look like an sheet in body of mail?

Thanks
Sahil Verma