How to e-mail current sheet as an attachment ???
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: How to e-mail current sheet as an attachment ???

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Doug Potter
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Excel 2000

    Thanks

    Doug

  2. #2
    New Member
    Join Date
    Apr 2002
    Location
    Milwaukee, WI
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this:

    File > Send To > Mail Recipient (As Attachment)...

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Doug Potter
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    File - Send To attaches the entire workbook.

    Thanks

    Doug

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Milwaukee, WI
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I see. Well, you could try copying the sheet to a new workbook, then send that workbook. This code will do the copying and will open the email. You have to enter the recipient's address and send it manually:

    Code:
    ActiveSheet.Copy
    Application.Dialogs(xlDialogSendMail).Show

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You will need to go to >> Send to >>> Mail Recipient as attachment>>

    Then excel will ask you if you want to send the whole document or just the selected sheet.Hope that helps you to perform your task.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Garth

    Visions_Fugitive
    Board Regular

    Joined: Apr 16, 2002
    Posts: 9
    From: Milwaukee, WI
    Posted: 2002-04-17 07:21
    --------------------------------------------------------------------------------
    Try this:

    File > Send To > Mail Recipient (As Attachment)...

    ||||||||||||||||||||||||||||||||||

    you posted some four hours later ??? the board has been asnswered and you post offeres little advance, i welcom and warmly thank all posters for help even if negative that is does not work but was sent in good faith and is related to topic... here you say just the same... do you not read the posts and all the feed, i have noticed this has happened before....

    Im not digging you or bing hostile, but credit the posters work is all im hinting at and read the posts fully... never know might learn from the wonderful guys, i know i do every day.

    your post timed
    Posted: 2002-04-18 01:06
    but was answered at
    Posted: 2002-04-17 07:21


    gareth
    Board Master

    Joined: Apr 16, 2002
    Posts: 73
    From: Cape Town,South Africa
    Posted: 2002-04-18 01:06
    --------------------------------------------------------------------------------
    You will need to go to >> Send to >>> Mail Recipient as attachment>>

    Then excel will ask you if you want to send the whole document or just the selected sheet.Hope that helps you to perform your task.

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com