Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Email a Selection of Addresses using sendobject

Discussion in 'Information Technology' started by Confused Slug, Jul 28, 2006.

  1. Confused Slug

    Confused Slug
    Expand Collapse
    Guest

    I have a number of check boxes that represent a list of people to which a
    report is sent via sendobject. One, many or all of the check boxes may be
    'ticked'.

    How can you configure access to send one email to all the recipients (based
    on the ticked boxes) rather than sending a seperate email to each?
     
  2. Loading...


  3. Dennis

    Dennis
    Expand Collapse
    Guest

    In your code, have a string variable called something like strTo and then
    loop around your check boxes and append names to the strTo string with a semi
    colon to separate the list of names to receive the E-Mail
    e.g.
    if chkbox = true then
    strTo = strTo & strName & ";"
    end if

    "Confused Slug" wrote:

    > I have a number of check boxes that represent a list of people to which a
    > report is sent via sendobject. One, many or all of the check boxes may be
    > 'ticked'.
    >
    > How can you configure access to send one email to all the recipients (based
    > on the ticked boxes) rather than sending a seperate email to each?
     

Share This Page