+ Reply to Thread
Results 1 to 3 of 3

VB code to "Send To" Multi addresses

  1. #1
    muzzas news
    Guest

    VB code to "Send To" Multi addresses

    I have a line of VB code to send a spreadsheet by e-mail to a recipient. I
    have tried modifying this to allow me to send to more than one recipient but
    can't get it to work.
    Currently I have:
    ActiveWorkbook.SendMail Recipients:= "abcgm@powerup.com.au"

    Help will be appreciated

    Murray



  2. #2
    Guest

    VB code to "Send To" Multi addresses

    hi
    see this site. there are 2 good suggestions here for you.

    http://www.rondebruin.nl/sendmail.htm

    >-----Original Message-----
    >I have a line of VB code to send a spreadsheet by e-mail

    to a recipient. I
    >have tried modifying this to allow me to send to more

    than one recipient but
    >can't get it to work.
    >Currently I have:
    >ActiveWorkbook.SendMail

    Recipients:= "abcgm@powerup.com.au"
    >
    >Help will be appreciated
    >
    >Murray
    >
    >
    >.
    >


  3. #3
    Markus Scheible
    Guest

    VB code to "Send To" Multi addresses

    Hi Murray,

    see the Excel help for some help ;o)

    cited:

    "Recipients: Required Variant. Specifies the name of the
    recipient as text, or as an array of text strings if there
    are multiple recipients. At least one recipient must be
    specified, and all recipients are added as To recipients."

    So simply connect a range with the recipients as follows:

    ActiveWorkbook.SendMail Recipients:=Range("A1", "A3")

    Or you first read your recipients in an array and conntect
    this with the recipients... whatever ;o)


    Best

    Markus


    >-----Original Message-----
    >I have a line of VB code to send a spreadsheet by e-mail

    to a recipient. I
    >have tried modifying this to allow me to send to more

    than one recipient but
    >can't get it to work.
    >Currently I have:
    >ActiveWorkbook.SendMail

    Recipients:= "abcgm@powerup.com.au"
    >
    >Help will be appreciated
    >
    >Murray
    >
    >
    >.
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1