Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Br. Columbia, Canada
    Posts
    109
    Thanks
    1
    Thanked 0 Times in 0 Posts

    How can I email a range from a sheet ?

    I have a worksheet that grows daily. At the end of each month I have to send the info to the owner via email. Does anyone know how I can send just one month's data as an attachment.
    Currently I have to send the whole sheet and it's taking longer & longer to send.
    Copy & Paste into the body of the message just doesn't cut it for him.
    Thanx for any tips here

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Do you need to send it in Excel? Or could you print it? I'm thinking about Custom Views here.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    New Lounger
    Join Date
    Aug 2010
    Location
    Riverside, CA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You could filter to a new sheet just the month(s) you need and then send that monthly sheet to owner. That would make creating the sheet easier by using a custom filter and by displaying the data in a new sheet you'd be able to just send that month of info without all the rest. A lot more to it than 2 sentences but it is definitely doable.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Ron DeBruin has some code at: http://www.rondebruin.nl/mail/folder1/mail4.htm to email a range in an excel sheet which you may be able to adapt

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Br. Columbia, Canada
    Posts
    109
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I have managed to send this way. I copy the range to a new book and send it that way. Just wondered if there was something quicker and easier to achieve this.

    Webgenii: Yes it has to be in Excel as he then adds the info to his worksheet.
    Mwibben: Not used filter's. Something new to explore and to learn about. Thanx.
    sdckapr: Thanx too for the link to code. Again something I have never ventured into. Another thing to learn?

    Thanx everyone.

Posting Permissions

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