Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    E-mail current worksheet (2000)

    I know I have seen VBA code somewhere whereby you can run a macro that will e-mail the current worksheet. I just can't seem to find it anywhere! Any help?

  2. #2
    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

    Re: E-mail current worksheet (2000)

    try looking under search (right next to Main Index on the top panel of the lounge)
    enter in something like (no quotes) "email worksheet" and browse through the hits to see if any meet your needs

    Steve

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: E-mail current worksheet (2000)

    See if This Thread will get you started.
    Legare Coleman

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: E-mail current worksheet (2000)

    The following code creates a new workbook from the active worksheet and snds it a given email address :

    Sub MailActiveSheet()
    ActiveSheet.Copy
    With ActiveWorkbook
    .SendMail Recipients:="emailaddress" ' <-Enter valid email address here
    .Saved = True
    .Close
    End With
    End Sub

    Andrew C

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: E-mail current worksheet (2000)

    Will I have access to my address book in Outlook?

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: E-mail current worksheet (2000)

    I'm not sure what you mean by access to your Outlook address book, but if Outlook is your default mail client you can supply a contact from your address book and the correct email address should be used.

    If you require a listbox of names so that you cxan make a selection from the address book, then I think you would need to interact with Outlook via automation.

    Andrew

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: E-mail current worksheet (2000)

    Thanks, Legare.

Posting Permissions

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