Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Excel 2007 - Send a selection as a mail Message Body

  
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Excel 2007 - Paste picture link does not print  
Author Message
Seanie

External


Since: Jan 23, 2009
Posts: 4



(Msg. 1) Posted: Sat Jan 24, 2009 8:46 am
Post subject: Excel 2007 - Send a selection as a mail Message Body
Archived from groups: microsoft>public>excel (more info?)
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

 >> Stay informed about: Excel 2007 - Send a selection as a mail Message Body 
Back to top
Login to vote
Seanie

External


Since: Jan 23, 2009
Posts: 4



(Msg. 2) Posted: Sat Jan 24, 2009 11:23 am
Post subject: Re: Excel 2007 - Send a selection as a mail Message Body
Archived from groups: per prev. post (more info?)
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

 >> Stay informed about: Excel 2007 - Send a selection as a mail Message Body 
Back to top
Login to vote
Ron de Bruin

External


Since: Dec 2, 2008
Posts: 17



(Msg. 3) Posted: Sat Jan 24, 2009 3:25 pm
Post subject: Re: Excel 2007 - Send a selection as a mail Message Body
Archived from groups: per prev. post (more info?)
Hi Seanie

[URL="http://www.rondebruin.nl/notinribbon.htm"]http://www.rondebruin.nl/notinribbon.htm[/URL]

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
 >> Stay informed about: Excel 2007 - Send a selection as a mail Message Body 
Back to top
Login to vote
Ron de Bruin

External


Since: Dec 2, 2008
Posts: 17



(Msg. 4) Posted: Sat Jan 24, 2009 7:25 pm
Post subject: Re: Excel 2007 - Send a selection as a mail Message Body
Archived from groups: per prev. post (more info?)
> 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
 >> Stay informed about: Excel 2007 - Send a selection as a mail Message Body 
Back to top
Login to vote
Seanie

External


Since: Jan 23, 2009
Posts: 4



(Msg. 5) Posted: Sun Jan 25, 2009 1:50 am
Post subject: Re: Excel 2007 - Send a selection as a mail Message Body
Archived from groups: per prev. post (more info?)
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
 >> Stay informed about: Excel 2007 - Send a selection as a mail Message Body 
Back to top
Login to vote
Ron de Bruin

External


Since: Dec 2, 2008
Posts: 17



(Msg. 6) Posted: Sun Jan 25, 2009 6:25 am
Post subject: Re: Excel 2007 - Send a selection as a mail Message Body
Archived from groups: per prev. post (more info?)
Back to top
Login to vote
Ron de Bruin

External


Since: Dec 2, 2008
Posts: 17



(Msg. 7) Posted: Sun Jan 25, 2009 8:25 am
Post subject: Re: Excel 2007 - Send a selection as a mail Message Body
Archived from groups: per prev. post (more info?)
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
 >> Stay informed about: Excel 2007 - Send a selection as a mail Message Body 
Back to top
Login to vote
Seanie

External


Since: Jan 23, 2009
Posts: 4



(Msg. 8) Posted: Sun Jan 25, 2009 10:31 am
Post subject: Re: Excel 2007 - Send a selection as a mail Message Body
Archived from groups: per prev. post (more info?)
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
 >> Stay informed about: Excel 2007 - Send a selection as a mail Message Body 
Back to top
Login to vote
Ron de Bruin

External


Since: Dec 2, 2008
Posts: 17



(Msg. 9) Posted: Sun Jan 25, 2009 3:25 pm
Post subject: Re: Excel 2007 - Send a selection as a mail Message Body
Archived from groups: per prev. post (more info?)
I think it is also stupid that it is not in this menu

OfficeButton>Send
 >> Stay informed about: Excel 2007 - Send a selection as a mail Message Body 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Unable to open excel 2007 file in excel 2002 despite havin.. - Hi I have installed office compatibility pack for office 2007. However, every time I try to open an xlsx file, I get unrecognized format error in Excel 2002. I can open docx without an issue. It appears to be that the problem is related specifically....

Excel 2003 toolbars in Excel 2007 - I have used Excel 2003 for years and have made a rather heavy customization by defining new toolbars with buttons calling VBA. Unfortunately, with Excel 2007 toolbars no longer exist! Gates and his gang of developers have decided that we all have to..

Excel 2007 "Trusted Locations" - Is there any way to get Excel 2007 to let you use removable media as a "trusted location"? my a*istant has a Zip drive hooked to her PC that she's using as basically an external hard drive, but whenever she opens a saved spreadsheet, it alw...

Excel 2007 Won't print some borderlines - I am attempting to print a spreadsheet of accounts on which I have used a dotted line (Rt-click / Format Cells/ Borders / Line) so that the accountant can easily follow the lines of income and expenditure. They all show up fine on the Print Preview..

Application.FileSearch in Excel 2007! - Hello, I recently upgraded to 2007 about 8 months ago, and had not run this report I developed since the upgrade and have since googled and found that Application.FileSearch no longer exists. I have been trying to use some of the code snippets to modify....
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]