I have 5 tabs showing in the workbook - I want to email a single sheet without having to email the entire workbook - any ideas - thanks in anticipation.
I have 5 tabs showing in the workbook - I want to email a single sheet without having to email the entire workbook - any ideas - thanks in anticipation.
Hi,
Take a look at Ron's solution ...
http://www.rondebruin.nl/mail/folder1/mail2.htm
Thanks for prompt reply - regret I'm lost - sorry.
Whilst I am in Excel - and go to the email box - it sends out the workbook as opposed to a single worksheet. I did have a quick glance at your suggested solution - didnt seem as simple as I was hoping for.
Ron has built all the possible combinations to all email issues ...
For your information, a worksheet does not have its existence outside of its workbook, so a shortcut for you would be : to copy the one sheet you need to email to a new workbook, and email that workbook ...
CARIM:
Thank you once again for a prompt reply.
In the past, I've choosen to save the file;
Delete all other tabs,
Email the workbook that contains a single sheet only.
Then click out of the file and without saving it, therefore retaining original file.
I have also emailed as you have suggested - copy worksheet.
I was hoping? maybe for a more speedier solution.
Thank you once again.
Hello jacko40,
Add a standard VBA module to your workbook. Copy and paste the code below into it. This will e-mail the active worksheet only in the body of the email. The user doesn't have to open a workbook to view it. Dependinging on how complex the formatting is, it may take a while. It may even appear that Excel has hung. Don't worry, it hasn't. This uses Oulook to do the emailing. So be sure Outlook has been set up properly before emailing anything.
Here is how to run the macro from code...Please Login or Register to view this content.
EmailWorksheet "[email protected]", "HTML Worksheet in Body without a Temp Workbook"
Other options can be added. Let me know if you want to do add something.
Sincerely,
Leith Ross
Leith Ross.
Thank you - it is greatly appreciated.
Background:
Recently (Jan 07), 2 additional computers were bought in.
Whenever a person using either of the new computers, is working in Excel (workbook) and say for example they are in sheet 3 of say 5 worksheets.
They click on the email icon - select from the address book the person they wish to send that email to. Then click on send.
The receiver of the email - on receipt and then opening up - receives only the single worksheet which has the data/info displayed on screen - not in an excel format - but similar to a word document - there are no additional excel tabs shown with the message, and in that format - they cant perform any excel functions.
At this point in time - we are looking at the "set up".
Given that you were kind enough to include your email address - I shall email to you, both the workbook (spurious data - nothing private or confidential), and what the recipient receives as a single sheet.
Once again - thank you for taking the time and trouble to reply.
Kindest regards,
Jack Houghton
Ireland
[email protected]
Hello Jacko40,
Go raibh mile maith agat. Nil a bhuiochas ort. That's about as much Irish as I know. I am looking forward to the email and the opportunity to help you on this.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi.
If you are working with a Excel spreadsheet - with multiple worksheets contained in the same workbook, and you have a need or requirement to email a single page from that workbook - and without sending the entire workbook.
1: Make sure that first you have dropped the email icon onto your menu bar.
2: There are two icons - each has a different function. One has a paper clip as in attachment - the other has an envelope - this is the one you require.
3: Select the worksheet so that it is open view on your PC.
4: Click on the 2nd icon.
5: Your view is now prepared to send the email. You add the address and then click on send.
6: If your microsoft outlook is already set up - the email will go out immediatly.
7: If its not set up, you will be prompted with a message to that effect.
8: Once sent, the recipient will receive the document - that is in a form whereby it can be read - but does not allow for calculation.
In closing - I hope the above makes sense - I'm just excited.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks