Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: emailing worksheet

  1. #1
    Guest

    Default

    I use this code to email a workbook:
    Sub SendIt()
    Application.Dialogs(xlDialogSendMail).Show _
    arg1:="email address", _
    arg2:="subject"
    End Sub
    The questions I have are, how can I just send one worksheet instead of the whole workbook?

    And, I have outlook and express on my computer, will or how can this work on other email software,ie.AOL,Lotus Notes?

    Thanks,

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Ireland
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I use lotus notes. I just tried it and it works! I can't say I'd ever have been able to come up with that code and I think it's pretty cool! I see somebody else has a question regarding how to do this at http://www.mrexcel.com/board/viewtop...1594&forum=2&0. Maybe you could help?

    [ This Message was edited by: y2k on 2002-03-08 02:50 ]

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    All you need to do is use some code like:

    Sheet1.Copy

    This (by deafault) will create a copy of your Worksheet in a Workbook that only contains the one sheet.



Some videos you may like

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
  •