Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sendmail (multiple recipients) (2000/XP)

    I'm trying to send a workbook to multiple recipients via sendmail.

    Is this possible?

    What would the code be?

    I've looked around rondebruin and it seems to be much more than what I need. The recipients are the same every time.

    Thanks!

  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: Sendmail (multiple recipients) (2000/XP)

    Check out this it has plenty of example code

    Steve

  3. #3
    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: Sendmail (multiple recipients) (2000/XP)

    You were just a little quicker on the draw, but great minds do think alike.
    Steve

  4. #4
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sendmail (multiple recipients) (2000/XP)

    Both of you were quicker than my edit.

    I've tried there and it seems to do more than what I want it to do. I just need to send the active workbook to multiple recipients.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Sendmail (multiple recipients) (2000/XP)

    OK, if you don't like ron debruin, and the recipients are always the same, you can hardcode them into an Array such as (it's been a while, you may have to debug):

    ThisworkBook.SendMail Recipients:=Array("bob@here.com", "carol@there.com", "ted@where.com", ...)
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Sendmail (multiple recipients) (2000/XP)

    See my edit to your edit! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Sendmail (multiple recipients) (2000/XP)

    I believe I owe that site to you, sir! <img src=/S/salute.gif border=0 alt=salute width=15 height=20>
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sendmail (multiple recipients) (2000/XP)

    That did it...thanks a bunch.

  9. #9
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sendmail (multiple recipients) (2000/XP)

    Well, I spoke too soon.

    I have the code in my Personal.xls sheet and it sends THAT out.

    I guess I'll need to play with it some.

  10. #10
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sendmail (multiple recipients) (2000/XP)

    Spoke too soon again...

    Change it to ActiveWorkbook rather than ThisWorkbook seems to have done the trick.

    I'm done now.

  11. #11
    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: Sendmail (multiple recipients) (2000/XP)

    You discovered the difference between "this" and "active"Workbook.

    This workbook is workbook with the code. Active workbook is the "active workbook". They are often interchangeable,
    BUT
    A hidden workbook (like personal.xls) can never be active (because it is hidden)

    Steve

Posting Permissions

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