Closed Thread
Results 1 to 9 of 9

How to email a single worksheet ?

  1. #1
    Registered User
    Join Date
    03-05-2007
    Posts
    6

    Question How to email a single worksheet ?

    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.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Take a look at Ron's solution ...
    http://www.rondebruin.nl/mail/folder1/mail2.htm
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    03-05-2007
    Posts
    6

    Unhappy

    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.

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    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 ...

  5. #5
    Registered User
    Join Date
    03-05-2007
    Posts
    6

    Smile

    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.

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    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.

    Please Login or Register  to view this content.
    Here is how to run the macro from code...
    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

  7. #7
    Registered User
    Join Date
    03-05-2007
    Posts
    6
    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]

  8. #8
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    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!)

  9. #9
    Registered User
    Join Date
    03-05-2007
    Posts
    6

    Talking

    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.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1